Whatz the main diff between Subquery and a Join
- 14 Answers
- 29121 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh
Join:
It is the machanism of joining one or more tables together
and finding information from one or all tables used in join.
Sub Query:
It is a method of finding answer using another query as
parametere for first query.
Main Difference:
In join both the tables should have a comman column type
but in subquery without having a column type we can execute
the query.
| Is This Answer Correct ? | 17 Yes | 16 No |
Post New Answer View All Answers
What is user managed backup in Oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the Tune Query
How to get last row id?
What is oracle data type?
What happens in oracle commit?
What is index-organized table in Oracle?
How to shutdown your 10g xe server from command line?
How to use "out" parameter properly?
What is query image?
What is an oracle user role?
What is a nvl function? How can it be used?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the meaning of recursive hints in oracle?
How to generate query output in html format?
