What are joins..how many types of joins are there?
Answer Posted / rahul baheti
Joins means we can join two or more then two table in
single query. and joins is combinatoin of two or more table.
there are Four type of join
1 Equi joins
2 Non Equi joins
3 Outer joins
4 Self joins
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How data locks are respected in oracle?
How to define an anonymous procedure with variables?
what is dynamic SGA and static SGA
Which environment variables are absolutely critical in order to run the OUI?
Does facebook use oracle?
How to rename an index?
What is rowid and rownum in oracle?
What are temporal data types in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to commit the current transaction in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What are the differences between blob and clob in oracle?
What are the types of trigger in oracle?
Explain the use of file option in exp command.
what is the difference between substr and instr function in oracle?