1. What are the different types of joins?2. Explain normalization with examples.3. What cursor type do you use to retrieve multiple recordsets?4. State the difference between a "where" clause and a "having" clause5. What is the difference between "procedure" and "function"?6. How will you copy the structure of a table without copying the data?7. How to find out the...

rr

• Apr 19th, 2017

Full OUTER also...is nothing but combination of Left and Right Outer Joins

vishal bansal

• Jul 28th, 2016

This answer is incomplete... we have in total 6 types of joins from Oracle 10g onwards

Cross joins
Inner joins
Outer joins
Equi and non-equi joins
Self joins
Partitioned joins

Answer Question  Select Best Answer