How do you get all records from 2 tables. Which join do you use?
Answers were Sorted based on User's Feedback
Answer / pervez
using full outer join or Cartesian join we can get all records
from two tables
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / gvmahesh
full outer join.
select ename,sal,dname,loc,e.deptno from emp e
full outer join dept d on e.deptno=d.deptno;
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kavithanedigunta
full outer join in 10 g
select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO
full outer join in 9i
select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
What is not in sql?
define data blocks ? : Sql dba
How to read xml file in oracle pl sql?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
Explain table and field in sql?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
Is sql between inclusive?
How to come back in normal stage in Mutating Table if mutating table is locked or update data?
What is meant by cursor in sql?
how to create a primary key with out creating an index?
what is rollback? : Sql dba