Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45324 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
Can a formula column referred to columns in higher group ?
How to delete multiple rows from a table in oracle?
What is a data lock in oracle?
How do I call oracle stored procedures that take no parameters?
How to select all columns of all rows from a table in oracle?
How to pass parameters to procedures?
In the oracle version 9.3.0.5.0, what does each number shows?
Can we protect our pl/sql source code?
What is Reduced List of Values?
material view and view disadvantages?
How to insert a new row into a table in oracle?
Please explain oracle left join with an example?
 How to use an oracle sequence generator in a mapping?
How to define a sub function?
Respected sir, Please send me technical questions related to oracle apps..
