What are the steps you take to tune(performance tuning) the code in plsql?
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 |
Post New Answer View All Answers
Explain ttitle and btitle.
Explain architecture of sql server notification services?
What is primary key and foreign key?
How many types of sql are there?
Does access use sql?
How do you modify a column in sql?
Which table is left in join?
What are the different schemas objects that can be created using pl/sql?
Is stored procedure faster than query?
how do you know if your mysql server is alive? : Sql dba
Can we use two order by clause in query?
Why do we use sql constraints?
Write a sql query to get the third highest salary of an employee from employee_table?
Is clustered index a primary key?
What are the types of index in sql?