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

How can a function retun more than one value in oracle with proper example?

1121

What is a primary key called that is made up of more than one field?

1393

What are sql functions? Describe the different types of sql functions?

1208

What are the different set operators available in sql?

1076

What are the set operators in sql?

1135

What steps server process has to take to execute an update statement?

1016

How do you update f as m and m as f from the below table testtable?

1928

What is trigger types of trigger?

1139

What does select * from mean in sql?

3329

What is sql*plus?

1120

how to convert character strings to dates? : Sql dba

1094

Does sql require a server?

1055

How many types of tables are there?

994

What are the differences between implicit and explicit cursors?

1109

What is the difference between pl and sql?

1153