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 a schema sql?

1147

What are instead of triggers?

1041

What are the ways on commenting in a pl/sql code?

1131

how can you create an empty table from an existing table? : Sql dba

1152

What are the different ddl commands in sql?

1164

Is merge a dml statement?

976

Describe sql comments?

1033

Why do we use function in pl sql?

1058

Does truncate table reset auto increment?

991

Does group by remove duplicates?

1038

Does truncate free space?

1005

What is a pl/sql block?

1222

Explain the steps needed to create the scheduled job?

1036

what are the difference between clustered and a non-clustered index? : Sql dba

1030

What is execution plan in sql?

1041