Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 4111 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 |
State and explain about oracle instance?
Explain the use of full option in exp command.
difference between procedures and function?
How many types of segments in Oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
hai, when to use char and varchar2....?
Why packages are used in oracle?
How to drop a tablespace?
what is the use of system.effective.date variable in oracle?
How to select some columns from a table in oracle?
How to load excel data sheet to oracle database
What is the difference between Outer join and Full outer join?
Oracle General 
