select * from table full outer join tablename2; or select * from tab

full outer join syntax

Question Posted / naresh

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

Please Help Members By Posting Answers For Below Questions

What is data control language (dcl)?

1131

How do I create a memory optimized filegroup?

958

What is PL/SQL Records?

1181

What is a pragma statement?

1262

What is the basic structure of an sql?

1098

What is cascade in sql?

958

What is clause in sql?

1106

What is sql architecture?

1041

What is basic structure of pl sql?

1066

How can we find duplicate records in a table?

939

Is sql an operating system?

1016

what is the difference difference between procedure and packages

10387

What is the purpose of normalization?

1038

What does (*) mean in sql?

945

How many triggers can be applied on a table?

928