full outer join syntax
Answers were Sorted based on User's Feedback
Answer / thiyagarajan
select table1.columnname1,table2.columnname2
from
table1 full outer join table2
on
table1.colname=table2.colname
Is This Answer Correct ? | 13 Yes | 1 No |
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;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / avi007
full outer join -
select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / naresh
select * from table full outer join tablename2;
or
select * from table1,table2 where
table1.columnname(+)=table2.colunmname(+);
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / ambedkar
At first Full outer join is never not possible.
Is This Answer Correct ? | 0 Yes | 4 No |
What are different types of keys?
What is break?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is the use of triggers?
How do you write an index?
How delete all data from table in sql?
What is sql and its types?
Explain the usage of WHERE CURRENT OF clause in cursors ?
What is the diffrence between IN and EXISTS.which one is faster.
why should required for Indexed by table in pl/sql
What is sqlcommand?
State the difference between implict and explict cursor's?