Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 4021 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 |
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is coalesce function?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
What is the difference between view and materialized view in Oracle?
How to insert multiple rows with one insert statement in oracle?
what is the difference between first normal form & second normal form?
How can I create database in oracle?
How to load a large xml file?
what is the scenario where you take the database to NoArchivelog mode?
How to create additional tablespaces for an new database?
How can I combine multiple rows into a comma-delimited list in oracle?
What happens to the current transaction if the session is killed?
Oracle General 
