Whatz the main diff between Subquery and a Join
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
if you ctreate table identity
What is a private synonym?
How many types of cluster table in Oracle?
How to find out what oracle odbc drivers are installed?
What privilege is needed for a user to query tables in another schema?
What is a proxy class?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is hash cluster in oracle?
What is oracle server autotrace in oracle?
How to connect to a local oracle 10g xe server?
How to synchronize 2 schema's objects?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is the use of oracle?
How to retrieve data from an cursor to a record?
What is archive log in Oracle?