What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3092 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 |
DBMS vs. RDBMS
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
How to define a specific record type?
How to create a table in a specific tablespace?
Can we save images in a database and if yes, how?
Explain the use of record option in exp command.
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is blob data type in oracle?
difference between oracle8i and oracle9i
What is not equal to in oracle?
Differnce between view and index
Oracle General 
