Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE
- PROCEDURE num_test_as_integer IS
- x INTEGER;
- t NUMBER := dbms_utility.get_time;
- BEGIN
- FOR i IN 1..10000000 LOOP
- x := i;
- END LOOP;
- dbms_output.put_line((dbms_utility.get_time-t)||'cs');
- END;
- -------------------------------------------
- PROCEDURE created.
- SQL> EXEC num_test_as_integer
- 500cs (среднее значение 5 выполнений)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement