What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3132 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nishi
Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they don't satisfy the join condition.
Equi-join--Its a join condition that retrieves rows from one or more tables in which one or more columns in one table are equal to one or more columns in the second table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / basanti
Joins and subquery both are different.
We don't use joins while writing subqueries.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is enter substitution variable in oracle?
what are different types of locks?
What is Index Cluster ?
How to delete an existing row from a table in oracle?
How to convert characters to times in oracle?
Explain self joins in oracle?
What are the advantages of Views ?
How to create a new tablespace in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
What is the difference between $oracle_base and $oracle_home?
How to start your 10g xe server from command line?
How do we switch from init.ora file to asp file?
Oracle General 
