Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33483 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
What are the uses of a database trigger?
How to open a cursor variable?
Why do we need oracle client?
What is a select query statement in oracle?
What is PL/SQL ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to use windows user to connect to the server?
How to loop through data rows in the implicit cursor?
Will you be able to store pictures in the database?explain.
What do you understand by database schema and what does it hold?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain about the analyze command in oracle?
What exactly do quotation marks around the table name do?
How to retrieve data from an cursor to a record?
what is difference between sql plus and sql*plus? (not sql and sql plus).
