How do you optimize a stored procedure query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Can delete statement be rollbacked?

0 Answers  


What is the usage of when clause in trigger?

0 Answers  


Why we use stored procedure instead of query?

0 Answers  


What is set serveroutput on?

0 Answers  


What is a database event trigger?

0 Answers  






1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  


how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  


how to get second highest salary in SQL(as/4000

29 Answers   iGate,


..........refers to the disk mirroring

2 Answers   iFlex,


Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,


How do I run a script in sql developer?

0 Answers  


How do I save the results of sql query in a file?

0 Answers  


Categories