Hello All,

Could any one provide me FAQs/interview questions on
oracle PL/SQL

Answer Posted / krishna

Plese see thin link: http://www.orafaq.com/wiki/PL/SQL_FAQ

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

536


What exactly do quotation marks around the table name do?

537


How to pass parameters to procedures in oracle?

563


Where do you use decode and case statements?

544


What is a read write transaction in oracle?

590






How to work with data objects interactively?

546


What is the scope of a local variable?

575


What is query image?

573


How do I limit the number of oracle database connections generated by weblogic server?

541


How to convert dates to characters in oracle?

575


How to loop through data rows in the implicit cursor?

537


What is the oracle implicit cursor?

582


What is the difference between Delete, Truncate and Drop in Oracle?

595


What would you do with an in-doubt distributed transaction?

1463


Explain how you would restore a database using RMAN to Point in Time?

1621