Interested to Buy Any Domain ? << Click Here >> for more details...
What are various joins used while writing SUBQUERIES?
- 2 Answers
- 4101 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 define a specific record type?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What happens in oracle commit?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is a trigger and what are its types?
What is enter substitution variable in oracle?
How to sort output in descending order in oracle?
What are ddl statements in oracle?
How to set a transaction to be read only in oracle?
Can group functions be used in the order by clause in oracle?
How many data types are supported?
What is meant by joins? List out the types of joins.
What are the uses of Database Trigger ?
How to convert a string to a date in oracle database?
Please explain oracle left join with an example?
