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
19292 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 sql and db2?

997

What is cursor explain with example?

982

What is where clause in sql?

1037

How is use pl and sql?

1059

What are stuff and replace function?

1076

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1022

What type of database is cloud sql?

1095

What is oracle and pl sql?

1118

What are the differences between implicit and explicit cursors?

1065

What is a temporal data type?

1045

Is it possible to update views?

957

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2017

What is a Mapplet?

1119

What are the triggers associated with image items?

1041

What sql database should I use?

1138