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

Is grant a ddl statement?

451

What is keys and its types?

538

How is pl sql different from sql?

543

What are the methods of filing?

516

Does truncate release storage space?

557

What is database sql?

539

What is the difference between delete and truncate commands?

511

What is nvl?

611

which types of join is used in sql widely? : Sql dba

539

What is snowflake sql?

578

How to Declare Fixed Length String Value In PL SQL

659

How do I count duplicates in sql?

545

what is auto increment? : Sql dba

569

What is trigger and stored procedure in sql?

554

What is embedded sql in db2?

505