What are joins..how many types of joins are there?
Answer Posted / guruswamy
join is combaining two or more tables.
there are three types.they are
1).simple join
2).self join
3).3.outer joins
| Is This Answer Correct ? | 15 Yes | 21 No |
Post New Answer View All Answers
How to drop an existing table in oracle?
Why we use bulk collect in oracle?
How many types of table in Oracle?
How to invoke the data pump export utility?
What is meant by a deadlock situation?
Can we insert data in view oracle?
How to retrieve values from data fields in record variables?
 How to use an oracle sequence generator in a mapping?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to use "out" parameter properly?
what is meant by magic query
How does Oracle guarantee data integrity of data changes?
Explain a segment?
What are the extensions used by oracle reports?
Explain the function of optimizer in oracle?