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
Can we call procedure inside function in oracle?
how to clone 9i Database on to 10g Database.
What is a database table in oracle?
How to open a cursor variable?
What is a cursor variable?
State and explain about oracle instance?
20. Using a set operator, display the client number of all clients who have never placed an order.
What happens to the current transaction if a ddl statement is executed?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is difference between cartesian join and cross join?
What is data file?
How to use fetch statement in a loop?
What are the types of trigger in oracle?
What are the arithmetic operations?
How do I start tns listener?