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.

How do I truncate a sql log file?

0 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

What is sql keyword?

0 Answers  

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

What is synchronized subquery?

0 Answers  

How does stored procedure reduce network traffic?

0 Answers  

Is sql easier than java?

0 Answers  

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

What is sql used for?

0 Answers  

When is a declare statement required?

0 Answers  

What port does sql server use?

0 Answers