Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45101 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / neo devan
A query inside a query or next level query is called
subquery, a subquery can return 1 or more values to the
main query.
Ex: select * from emptable where deptno=(select deptno from
saltable where rownum=1);
A Join is used to query two tables, or views.
Ex: select * from emptable inner join saltable on
emptable.deptno=saltable.deptno;
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
How to rollback the current transaction in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
if you ctreate table identity
Explain the use of record length option in exp command.
What is oracle host variable?
What is a data dictionary and how can it be created?
Can select statements be used on views in oracle?
Explain the use of control file?
What is a nested table?
How to start instance with a minimal initialization parameter file?
What are the different windows events activated at runtime ?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Can a parameter be passed to a cursor?
How to experiment a data lock in oracle?
Explain about integrity constraint?
