Answer Posted / pandian raman
Inner Join (simple join)
Inner joins return all rows from multiple tables where the
join condition is met.
For example,
SELECT suppliers.supplier_id, suppliers.supplier_name,
orders.order_date FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id;
This SQL statement would return all rows from the suppliers
and orders tables where there is a matching supplier_id
value in both the suppliers and orders tables.
Outer Join
This type of join returns all rows from one table and only
those rows from a secondary table where the joined fields
are equal (join condition is met).
For example,
select suppliers.supplier_id, suppliers.supplier_name,
orders.order_date from suppliers, orders where
suppliers.supplier_id = orders.supplier_id(+);
This SQL statement would return all rows from the suppliers
table and only those rows from the orders table where the
joined fields are equal.
The (+) after the orders.supplier_id field indicates that,
if a supplier_id value in the suppliers table does not exist
in the orders table, all fields in the orders table will
display as <null> in the result set.
The above SQL statement could also be written as follows:
select suppliers.supplier_id, suppliers.supplier_name,
orders.order_date from suppliers, orders where
orders.supplier_id(+) = suppliers.supplier_id
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the maximum limit on the number of columns in a table?
How to start your 10g xe server?
Give the various rollback segment states.
What is the best way to do multi-row insert in oracle?
How are extents allocated to a segment?
What is an anonymous block?
How to connect the oracle server as sysdba?
In the oracle version 9.3.0.5.0, what does each number shows?
What do you mean by cdb and pdb in oracle 12c?
How many types of auditing in Oracle?
What are group functions in oracle?
Explain about your project and its relation to the current job position you are applying to?
What are the tools for Oracle ?
How to rebuild an index in oracle?
What is an oracle cursor variable?
