Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33527 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
How to update a table row with a record?
Point the difference between translate and replace?
Explain the use of control file?
How many types of tables are there in oracle?
What is pragma autonomous transaction in oracle?
How can we find out the duplicate values in an oracle table?
How to pass a cursor variable to a procedure?
What is a proxy class?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to connect to oracle using service name instead of sid?
How to return top 5 rows in oracle?
How to pass parameters to procedures in oracle?
What is the difference between translate and replace in oracle?
How to bring a tablespace online?
What are the system predefined user roles?
