Use Full Outer Join in Oracle 10g : SELECT p.part_id,s.supplier

How do you get all records from 2 tables. Which join do you use?

Question Posted / selvaraj v , anna univ coe

Use Full Outer Join in Oracle 10g :

SELECT p.part_id,s.supplier_name FROM part p
FULL OUTER JOIN
supplier s ON p.supplier_idv = s.supplier_id;

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is left join example?

959

Can we use views in stored procedure?

1043

Does sql between include endpoints?

1021

Are sql database names case sensitive?

1017

What is normalisation and its types?

1015

What is cartesian join in sql?

1141

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1061

What is thread join () in threading?

1020

How to change the order of columns in Oracle SQL Plus ?

1062

What is sql partition?

1117

How to handle bulk data?

1321

What is a full join sql?

1066

How do I order columns in sql?

1021

How do I copy a table in sql?

1001

What is pragma in sql?

1090