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
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What are set operators?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to add a new column to an existing table in oracle?
Explain what are the uses of rollback segment?
various types of hints and their usage
How will you identify oracle database software release?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is a private synonym?
What is the relation of a user account and a schema?
How do I manually create a database in oracle?
How do I manually uninstall oracle client?
if you ctreate table identity
Explain enable novalidate constraint.
What are internal user account in oracle?