Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33885 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna alla
Above one is exact answer that says sub query is used to get data based on unknown condition (example: select the employee's salary where employee salary greater than clerk) here first we find out clerk salary and then based on his salary we find employee's salary according to above query)
join is used to get the data from atleast 2 tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between open_form and call_form in oracle.
Why we use bulk collect in oracle?
What is merge in oracle?
What is the meaning of recursive hints in oracle?
What is a procedure in oracle?
How to download oracle database 10g xe?
ABOUT IDENTITY?
In oracle there is column command, how will you explain that?
What are the execution control statements in oracle?
What are the differences between interval year to month and interval day to second?
What happens to the indexes if a table is recovered?
How to execute a stored procedure in oracle?
What is difference between truncate and delete?
How to pass a parameter to a cursor in oracle?
What the is the diff between local index and global index. give some example.
