Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32989 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can I combine multiple rows into a comma-delimited list in oracle?
Explain oracle’s system global area (sga).
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What do you mean by redo log file mirroring?
What do you mean by cdb and pdb in oracle 12c?
Explain a data segment?
What is difference between cartesian join and cross join?
What is the exact use of Collections?
How would you begin to troubleshoot an ORA-3113 error?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain how are indexes update?
Difference between pre-select and pre-query
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain rename?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
