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

Query to retrieve record for a many to many relationship ?

What is SQL access advisor in Oracle?

what is difference between foreign key and reference key

what are actual and formal parameters?

How to check your oracle database 10g xe installation?

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

What are a cluster and non-cluster index?

What is save point in oracle database?

How to drop an index in oracle?

without using count(*) and rownum how can we count total record in a table

How can we Update a table with out using UPDATE command?

How can we find out the current date and time in oracle?

For more Oracle General Interview Questions Click Here