Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33039 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / anbu
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 ? | 17 Yes | 4 No |
Post New Answer View All Answers
What is a relational database management system?
What are the attributes that are found in a cursor?
How do I know if oracle is installed on windows?
How to check the server version in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the execution control statements?
Use of an integrity constraint is better to validate data. Explain
How to manage transaction isolation level?
What are the components of logical database structure in oracle database?
What privilege is needed for a user to query tables in another schema?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is the parameter mode that can be passed to a procedure?
How to create additional tablespaces for an new database?
What is pragma autonomous transaction in oracle?
what is the difference between substr and instr function in oracle?
