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 are the different types of sql commands?

1128

What are reports usually used for?

1023

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

what are the type of locks ? : Sql dba

966

What is the difference between left and left outer join?

945

What is synonyms?

1058

What does plv msg allows you to do?

1142

Which table is left in join?

979

How to make a copy values from one column to another in sql?

1037

Can we write ddl statements in functions?

1117

What is rownum and rowid?

1033

What are variables in pl sql?

1168

Does sql view stored data?

960

Why partition by is used in sql?

1043

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3570