Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32895 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / rajesh
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 ? | 78 Yes | 27 No |
Post New Answer View All Answers
Can we protect our pl/sql source code?
What is Segment Advisor in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to convert characters to numbers in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to write a query with an inner join in oracle?
What are joins, explain all types of joins?
How will you differentiate between varchar & varchar2?
How to create a temporary table in oracle?
What is a server parameter file in oracle?
How to set up autotrace for a user account?
Explain temporal data types in oracle
Please explain oracle left join with an example?
How to count groups returned with the group by clause in oracle?
