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 |
How many null values can be inserted in a coulmn whihc is unique constraint
can we delete the trigger in a view? if yes why if not why?
Does truncate table reset auto increment?
What is difference between primary and secondary key?
What is the difference between nvl function, ifnull function, and isnull function?
how many groups of data types? : Sql dba
Is inner join same as self join?
What are the blocks in stored procedure?
What does 0 mean in sql?
Why are aggregate functions called so?
can we use out parameter in a function?Give an example.
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.