Whatz the main diff between Subquery and a Join
Answer Posted / siva
Sub Query:
The Sub Query only get the results as one table or the
other table based that the result be of onther table as
used in the table.
The two tables information are dispalyed as combiend.
Join:
To get results more rhan two tables information.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is java oracle used for?
How to use "if" statements on multiple conditions?
How to list all indexes in your schema?
How to define an external table with a text file?
How oracle handles dead locks?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to rename an index?
What is a package ? What are the advantages of package ?
What is difference between truncate and delete?
What are the different types of modules in oracle forms?
How to build data dictionary view an new database?
How many types of cluster table in Oracle?
How to rebuild an index in oracle?
How to define an oracle cursor variable?
What is SQL Tuning Advisor in Oracle?