Answer / thiyagarajan

select table1.columnname1,table2.columnname2
from
table1 full outer join table2
on
table1.colname=table2.colname

Answer / madhav

Full outer join

select e.empno,e.ename,e.deptno,e.sal,d.deptno,d.dname from
emp e full outer join dept d
on e.deptno=d.deptno;

Answer / avi007

full outer join -

select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);

Answer / naresh

select * from table full outer join tablename2;

or

select * from table1,table2 where
table1.columnname(+)=table2.colunmname(+);

Answer / ambedkar

At first Full outer join is never not possible.

What is the difference between function, procedure and package in pl/sql?

0 Answers  

What is dcl in sql?

0 Answers  

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

use of IN/ANY/ALL

5 Answers   Ramco,

What is a constraint?

0 Answers  

What is sqlerrd?

0 Answers  

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

how can we destroy the cookie? : Sql dba

0 Answers  

What is offset and limit in sql?

0 Answers  

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

How do you truncate?

0 Answers