What are joins..how many types of joins are there?
Answer Posted / t.murali krishna
Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What do you mean by group by clause?
How do you store pictures in a database?
How to save query output to a local file?
How to set a transaction to be read only in oracle?
Explain the use of owner option in exp command.
What is the difference between a hot backup and a cold backup in oracle?
What are the execution control statements in oracle?
What is Data Dictionary Cache in Oracle?
How can we find out the current date and time in oracle?
What is the difference between translate and replace?
What do you mean by cdb and pdb in oracle 12c?
What is an oracle database?
What are the different types of failures that occur in Oracle database?
What is Reduced List of Values?
How many file formats are supported to export data?