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
How would you change old and new values in an insert, delete and update triggers?
Does oracle charge for java?
What is the exact use of Collections?
How to rename a column in an existing table?
What are the tools for Oracle ?
interview questions with answer for cts
How to establish administrator authentication to the server?
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.
What is a nvl function? How can it be used?
What is a table in oracle?
What do you mean by group by clause?
Which environment variables are absolutely critical in order to run the OUI?
Can we write insert statement in function in oracle?
What are the various types of snapshots ?
What's dateware house and what's clustor with practicle example