What are joins..how many types of joins are there?
Answer Posted / neet verma
A JOIN is a means for combining fields from two tables by
using values common to each.
there are three types of joins:-
1)inner join
a)eqi join
b)natural join
c)cross join
2)outer join
a)Left outer join
b)Right outer joins
c)Full outer join
3) self join
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is a snapshot log?
What is an oracle cursor variable?
Is oracle a language?
What are the uses of synonyms?
Explain compound trigger in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to use subqueries with the exists operator in oracle?
How to connect to a remote server?
What privilege is needed for a user to create tables in oracle?
What is a package ? What are the advantages of package ?
What is the usage of merge statement?
What is oracle in java?
How to manage transaction isolation level?
Explain the use of ignore option in imp command.