What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3073 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to speed up webrick?
How can we view last record added to a table?
What is materialized view in Oracle?
How do I know if oracle client is installed on windows?
How do we create privileges in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to retrieve data from an cursor to a record?
what is the difference between restoring and recovering?
What do you mean by a tablespace?
How to resolve name conflicts between variables and columns?
What is a database table in oracle?
How to generate query output in html format?
How to assign a table row to a record variable?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is transaction control statement and how many types of transaction control statement in Oracle?
