Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33027 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
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
How to lock and unlock a user account in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is set operator oracle?
What are the attributes that are found in a cursor?
What is a package ? What are the advantages of package ?
What is the data type of dual table?
Name the three major set of files on disk that compose a database in Oracle?
How a tablespace is related to data files?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to resolve name conflicts between variables and columns?
How to use "in" parameter properly?
What are group functions in oracle?
Why cursor variables are easier to use than cursors?
Explain about integrity constraint?
How to import one table back from a dump file?
