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
Which function is used to return remainder in a division operator in sql?
What is pivot query?
What is a schema sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What are different types of indexes?
what is the difference between where clause and having clause? : Sql dba
Are stored procedures faster than queries?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How do I run a pl sql program?
What is primary and foreign key?
What is Collation Sensitivity ? What are the various type ?
Is sql open source?
what is the difference between char_length and length? : Sql dba
What are the different types of dbms?
What is a trigger word?