Oracle Interview Questions and Answers



1 . What is the Difference between a Join and Subquery ?

Answer : Joins are SELECT commands that retrieve data from two or more tables....



2. If i want to develop an oracle applications report using report builder 6i and if I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program ?

Answer : Create two new value sets for the parameters that are to be used...



3. What is the maximum size of a row in oracle 9i ?

Answer : The oracle is Unlimited of...



4. Difference between Procedure and Function ?

Answer : A procedure is a named PL/SQL block...




Related Searches to Oracle Interview Questions and Answers