Assign dbms_utility.get_time to integer variable

  

SQL>
SQL> create or replace procedure num_test_as_integer is
  2   x integer;
  3   t number := dbms_utility.get_time;
  4   begin
  5       for i in 1 .. 1000 loop
  6           x := i;
  7       end loop;
  8       dbms_output.put_line((dbms_utility.get_time-t)||'cs');
  9   end;
 10  /

Procedure created.

SQL>

Related examples in the same category

1.	This script demonstrates DBMS_UTILITY.NAME_TOKENIZE.
2.	Use dbms_utility to time
3.	time to commit
4.	dbms_utility.get_parameter_value
5.	Call dbms_utility.get_time twice to time a statement in PL SQL
6.	round dbms_utility.get_time
7.	Use dbms_utility.get_time to do performace check
8.	dbms_utility.format_error_stack
9.	Timing Per Thousand Records Processed (in secs)
10.	Timing Package function call
11.	use DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
12.	DBMS_UTILITY.analyze_schema
13.	demonstrates the use of DBMS_UTILITY.TABLE_TO_COMMA and DBMS_UTILITY.COMMA_TO_TABLE.
14.	Performace difference between simple parameter and collection parameter

Assign dbms_utility.get_time to integer variable : dbms_utility « System Packages « Oracle PL / SQL

Related examples in the same category