How do I decide when to use right joins/left joins or inner joins or how to dete

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

Question Posted / bhanu bhandula

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

More Oracle General Interview Questions

Explain a synonym?

How to use values from other tables in update statements using oracle?

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

What are group functions in oracle?

What is a system tablespace?

What is the difference between hot backup and cold backup in oracle?

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

How many types of auditing in Oracle?

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

Why we choose emp number as primarykey?

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

For more Oracle General Interview Questions Click Here