What are the steps you take to tune(performance tuning) the code in plsql?
- 4 Answers
- 16105 Views
- Cap Gemini, Infosys, TCS, I also Faced
- E-Mail Answers
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
What is query execution plan in sql?
Can we join two tables without common column?
Why do we use procedures?
Why do we create views in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is pl sql collection?
Which tcp/ip port does sql server run?
What are different clauses used in sql?
Define sql delete statement.
What is the difference between python and sql?
Why cross join is used?
What is the most important ddl statements in sql are?
What is relationship? How many types of relationship are there?
What is sqlexception in java?
What is normalization in sql?
