How do you get all records from 2 tables. Which join do you use?
Answer 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 |
Post New Answer View All Answers
Why commit is not used in triggers?
What are % type and % rowtype?
What is the purpose of my sql?
Is sql a oracle?
Which data type is a composite type?
Explain the insert into statements in sql?
What is %type in pl sql?
What are three advantages to using sql?
Can we alter stored procedure?
What are all ddl commands?
how to use myisamchk to check or repair myisam tables? : Sql dba
how to enter numeric values as hex numbers? : Sql dba
What are records give examples?
What is the difference between rollback and rollback to statements?
What is embedded sql with example?