full outer join in 10 g select a.*,d.dname from emp a full outer join

How do you get all records from 2 tables. Which join do you use?

Question Posted / kavithanedigunta

8 Answers
19216 Views
Microsoft, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between truncate and delete statement? : Transact sql

1045

Can we create clustered index without primary key?

948

Mention what pl/sql package consists of?

980

how do you know if your mysql server is alive? : Sql dba

1063

what is an extent ? : Sql dba

1073

how to concatenate two character strings? : Sql dba

1078

Why we use joins in sql?

965

how can we find the number of rows in a table using mysql? : Sql dba

1069

Is record in pl sql?

949

Does oracle use sql?

910

What is pragma in pl sql?

1087

How does sql store data?

892

Does sql full backup truncate logs?

1008

How long will it take to learn pl sql?

925

What is fmtonly in sql?

1061