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
Why is oracle database so popular?
How index is implemented in oracle database?
Explain the use of record length option in exp command.
How to delete a column in an existing table?
What is oracle rowcount?
How does the on-delete-cascade statement work?
What is a nvl function?
what are the default admin accounts in Oracle 10g ?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is analyze command used for?
What are the execution control statements in oracle?
What is an oracle wallet?
How to use attributes of the implicit cursor in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
What do you mean by merge in oracle?