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

How can you fetch first 5 characters of the string?

997

What is the use of procedures?

964

What is the need of merge statement?

1012

how to rename an existing column in a table? : Sql dba

1002

What is a pragma statement?

1251

How do you update a value in sql?

1022

how to rename an existing table in mysql? : Sql dba

1045

What is over () in sql?

932

Is sql better than excel?

1119

Which is faster count (*) or count 1?

1010

what are the limitations of identity column? : Transact sql

1088

What are database links used for?

1029

How many sql commands are there?

1102

Why left join is used in sql?

959

what is foreign key? : Sql dba

1001