Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 3889 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 generate query output in html format?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are the different oracle database objects?
How will you identify oracle database software release?
How to create id with auto_increment on oracle?
What is Trigger in Oracle?
What is oracle open database communication (odbc)?
What are the attributes of the cursor?
Can we store images in oracle database?
Explain drop constraint oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to rename a tablespace in oracle?
Explain do view contain data?
What are the limitations of check constraint?
How to do paging with oracle?
