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 importance of .pll extension in oracle?
How can I see all tables in oracle?
Is the After report trigger fired if the report execution fails ?
How to drop a tablespace?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to start an oracle instance?
How to rename a column in an existing table?
What is an external table?
Can group functions be mixed with non-group selection fields?
How to sort the query output in oracle?
What is the usage of merge statement?
How does oracle handle read consistency?
What is an oracle data file?
How to create tables for odbc connection testing?
How to put more than 1000 values into an oracle in clause?