What are various joins used while writing SUBQUERIES?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / basanti
Joins and subquery both are different.
We don't use joins while writing subqueries.
Is This Answer Correct ? | 0 Yes | 0 No |
 How to use an oracle sequence generator in a mapping?
What privilege is needed for a user to create views in oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
How to connect ms access to oracle servers?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is the data type of dual table?
How to drop an index?
What is the database name in oracle?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
Can we store images in oracle database?
What is columnar storage what is the advantage?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi