Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33883 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
How do I learn what codesets are available in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is clustered table in Oracle?
How to use fetch statement in a loop?
How many types of cluster table in Oracle?
What is a synonym? What are its various types?
Explain rename?
How would you begin to troubleshoot an ORA-3113 error?
What is hash cluster in oracle?
How to store only time; not date and time?
How to work with data objects interactively?
Give the different types of rollback segments.
What is the difference between a user and a schema in oracle?
What are the common oracle dba tasks?
what are actual and formal parameters?
