Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 4034 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 an anonymous block?
What is the relationship among database, tablespace and data file?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
How do I escape a reserved word in oracle?
What happens to the current transaction if the session is ended?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Explain the truncate in oracle?
List the various oracle database objects?
Is oracle a language?
what is primary key?
select * from emp what happened internally when we write this query in the sql prompt?
What are triggers?Where are they used?
Oracle General 
