Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 4106 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 a view?
What is an Oracle view?
What is the difference between implicit index and explicit index?
What is an oracle cursor variable?
How to check your oracle database 10g xe installation?
Why we choose emp number as primarykey?
What is a nvl function? How can it be used?
what are pseudocolumns?
what is grid in Oracle 10g...
what is Table ?
why pl sql doesn't support retrieving multiple records
What is a sub query? What are its various types?
Oracle General 
