Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32970 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suryakiran
The main usage of subqueries is to retrieve a single record
from that same table or another table.
And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.
We can perform all operations for joins by using subqueries
but it is very complicated.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
what is reindexing?
What is an Oracle Instance?
what happened to the global index when I truncate the data in one of the partition?
Explain the use of control file?
How to change user password in oracle?
How to get last row id?
How to increment dates by 1 in oracle?
Explain the use of grant option in exp command.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain how you would restore a database using RMAN to Point in Time?
What is the fastest query method to fetch data from the table?
20. Using a set operator, display the client number of all clients who have never placed an order.
