Whatz the main diff between Subquery and a Join
- 14 Answers
- 29278 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 compare dates in oracle sql?
What is oracle and what are its different editions?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is difference between cartesian join and cross join?
Can we convert a date to char in oracle and if so, what would be the syntax?
How remove data files before opening a database?
How to start an oracle instance?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How do I learn what codesets are available in oracle?
What is the difference between a user and a schema in oracle?
List out the difference between commit, rollback, and savepoint?
How to create an oracle testing table?
What is recovery manager in Oracle?
What is recycle bin in Oracle?
