Whatz the main diff between Subquery and a Join
Answer Posted / rajesh
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
Is This Answer Correct ? | 78 Yes | 27 No |
Post New Answer View All Answers
Explain the difference between a procedure and a function? What do you understand by those terms?
What is query image?
Is a rollback possible to any savepoint?
What are temporal data types in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to Truncate Table in Oracle
How do I escape a reserved word in oracle?
How to assign data of the deleted row to variables?
What is the best way to do multi-row insert in oracle?
What is an oracle database?
What is the order of defining local variables and sub procedures/functions?
What are dml statements in oracle?
What are the various types of snapshots ?
How to get the Installed Oracle Version Information ?
What to do if the binary spfile is wrong for the default instance?