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
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
master table and child table performances and comparisons in Oracle ?
How to delete an existing row from a table in oracle?
how to handle exceptions in post production
What is open database communication (odbc) in oracle?
Explain the use of consistent option in exp command.
What is the maximum limit on the number of columns in a table?
WHAT IS ecc 6.0
Can we save images in a database and if yes, how?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is the disadvantage of User defind function?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is a parameter file in oracle?
is there a tool to trace queries, like profiler for sql server?
What are the uses of linked server and explain it in detail?