What are various joins used while writing SUBQUERIES?

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


Please Help Members By Posting Answers For Below Questions

How would you change old and new values in an insert, delete and update triggers?

803


Does oracle charge for java?

851


What is the exact use of Collections?

1938


How to rename a column in an existing table?

830


What are the tools for Oracle ?

843


interview questions with answer for cts

2368


How to establish administrator authentication to the server?

811


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1785


What is a nvl function? How can it be used?

792


What is a table in oracle?

760


What do you mean by group by clause?

810


Which environment variables are absolutely critical in order to run the OUI?

1936


Can we write insert statement in function in oracle?

857


What are the various types of snapshots ?

811


What's dateware house and what's clustor with practicle example

1968