Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33542 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / a.n.v.v.siva kumar
The main difference between join and sub query is :
join is used to retrieve data from two different tables
where as in sub query we can retreive data from one table
using the result of the where condition on another table.
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
How to create a stored program unit?
What are the built-in functions used for sending Parameters to forms ?
Explain how you would restore a database using RMAN to Point in Time?
How many categories of data types?
Why use resource manager in Oracle?
What is the data pump import utility?
Why do we use coalesce function in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is query image?
Give syntax for SQL and ORACLE joins.
How to define a sub function?
How to define and use table alias names in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Which environment variables are absolutely critical in order to run the OUI?
What is the disadvantage of User defind function?
