How do you optimize a stored procedure in sql?


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

Post New Answer

More SQL PLSQL Interview Questions

How do I remove sql developer from windows 10?

0 Answers  


What is user in sql?

0 Answers  


What does bitemporal mean?

0 Answers  


How do I view a sql trace file?

0 Answers  


How do I start sql profiler?

0 Answers  






Define commit?

0 Answers  


write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,


one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,


What does count (*) mean?

0 Answers  


Does truncate require commit?

0 Answers  


How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,


Is oracle sql free?

0 Answers  


Categories