What are joins..how many types of joins are there?
- 29 Answers
- 76696 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
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
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How would you begin to troubleshoot an ORA-3113 error?
Explain oracle’s server parameter file.
Explain oracle’s system global area (sga).
How can I get column names from a table in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to drop a stored procedure in oracle?
How to export your own schema?
Is there any function in oracle similar like group_concat of mysql?
How to import one table back from a dump file?
Explain about functional dependency and its relation with table design?
What is dynamic proxy?
How to sort the query output in oracle?
What is Library Cache in Oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
