Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33422 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
How to invoke the original export import utilities?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
what is Single Byte Overhead...?
How to create additional tablespaces for an new database?
How to retrieve values from data fields in record variables?
What is Reduced List of Values?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to delete a column in an existing table?
How can I see all tables in oracle?
What is the use of aggregate functions in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the difference between online and offline backups?
Describe varray?
Explain the use of online redo log files in oracle.
What privilege is needed for a user to create views in oracle?
