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

How many tables can a sql database have?

927

What are some predefined exceptions in pl/sql?

1067

Does sql profiler affect performance?

942

what is the difference between where clause and having clause? : Sql dba

950

How to sort the rows in sql.

1011

how to concatenate two character strings? : Sql dba

1033

what is the difference difference between procedure and packages

10251

What is not equal in sql?

1011

What is record type in pl sql?

941

What is the difference between mdf and ndf files?

1063

What is string data type in sql?

1055

What are the constraints available in sql?

999

what is cursor. write example of it. What are the attributes of cursor.

1311

What is the mutating table and constraining table?

969

How do I order columns in sql?

914