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 the difference between delete and truncate statement in sql?

1009

What is cursor in pl sql with examples?

953

Is there any restriction on the use of union in embedded sql?

1099

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

Can you join a table to itself?

1029

What is rank () in sql?

882

What is a unique constraint?

1011

What is sql exception?

913

What is the difference between sql, mysql and sql server?

1013

How do you update a sql procedure?

970

What is indexes?

999

What is difference between hql and sql?

991

What is an alias command?

1003

What is difference between my sql and sql?

996

Is primary key clustered or nonclustered?

951