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 is a cursor in oracle?
Is oracle the best database?
How to define a variable to match a table column data type?
How to download oracle database 10g xe?
How to use "out" parameter properly?
Explain rename?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to assign values to data fields in record variables?
How many types of segments in Oracle?
What is ordinary table in oracle?
What is meant by a deadlock situation?
Why do we use bulk collect in oracle?
What is the implicit cursor in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What the is the diff between local index and global index. give some example.