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 an oracle tablespace?
How to use subqueries with the in operator using oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What are the differences between char and varchar2 in oracle?
Explain how are indexes update?
How to see the table columns used in an index?
How do we represent comments in oracle?
How to grant create session privilege to a user in oracle?
What is a nested table and how is it different from a normal table?
What are transaction isolation levels supported by oracle?
How to change system global area (sga) in oracle?
What is redo log?
Is oracle a language?
How to define an anonymous block?
Design database draw er diagram for a certain scenario ?