Whatz the main diff between Subquery and a Join
- 14 Answers
- 29060 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 an Oracle index?
How to export several tables together?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to change system global area (sga) in oracle?
What is pragma autonomous transaction in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain the features of oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
What is the minimum client footprint required to connect c# to an oracle database?
Where do we use decode and case statements?
How do I limit the number of rows returned by an oracle query after ordering?
How do I uninstall oracle client from windows?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Can sub procedure/function be called recursively?
