What are joins..how many types of joins are there?
Answer Posted / tauqueer
Joins means we can join two or more then two table in
single query.
there are 3 types of join..
1. INNER JOIN.
2. OUTER JOIN.
1.Left outer join.
2.right outer join.
3.full outer join.
3. CROSS JOIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a proxy object?
How to define an oracle cursor variable?
Explain the use of inctype option in exp command.
IS it possible to built the oracle database without setting the kernal parameters?
How data locks are respected in oracle?
Difference between hot backup vs. Cold backup?
How to convert characters to dates in oracle?
What is query image?
What privilege is needed for a user to delete rows from tables in another schema?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Can select statements be used on views in oracle?
how may join possible between (requisition with purchase order)
Can you drop an index associated with a unique or primary key constraint?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?