Answer Posted / anjum
There are four types of joins
Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join
Is This Answer Correct ? | 0 Yes | 0 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.
How to view the data files in the current database?
How to test null values?
What is partitioned table in Oracle?
What is a procedure in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
what is IDE,DMV in sql server?
How to delete a user account in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is the sql query to concatenate column values from multiple rows in oracle?
What happens to the indexes if a table is recovered?
What are the tools for Oracle ?
What is a snapshot log?
How to experiment a data lock in oracle?
What is meant by joins?