Explain cursor types?
What is spool?
I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????
What types of commands can be executed in sql*plus?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
What are different types of joins ?
Do you know the basic structure of PL/SQL?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
Can you inner join the same table?
Why is there a need for sqlcode and sqlerrm variables?
What is clause?
what is data control language? : Sql dba
Why we use sql profiler?