Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32877 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / srijina
join combines tables and retrieves data where as sub query
doesn't combines two table.join is more faster than subquery
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How do I spool to a csv formatted file using sqlplus?
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.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are the most common interview questions on ETL Testing for experience?
How to initialize variables with default values?
What is tns name?
What is a subquery in oracle?
How do you tell what your machine name is and what is its IP address?
What is merge statement used for?
List out the types of joins.
How to create additional tablespaces for an new database?
Whats the benefit of dbms_stats over analyze?
What is transport network substrate (tns) in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
Can we connect to ORACLE db using Windows Authentication?
