variable_first:=dbms_utility.get_time variable_last:=dbms_utility.get

What are the steps you take to tune(performance tuning) the code in plsql?

Question Posted / sandeep

Answer Posted / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

Is This Answer Correct ?

2 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What is a data definition language?

1027

What is record in pl sql?

1009

How can you get sql*loader to commit only at the end of the load file? : aql loader

965

What is the difference between in and between in sql?

994

Is pl sql a scripting language?

969

what is myisam? : Sql dba

1000

what is a table in a database ? : Sql dba

989

What is the difference between delete, truncate and drop command?

1060

What is varchar sql?

1058

What are % type and % rowtype?

979

What is schema in sql?

885

explain the delete statements in sql

976

how can we know the count/number of elements of an array? : Sql dba

1004

Is record in oracle pl sql?

902

what are null values? : Sql dba

899