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 does varchar include?

517

What is sql and also describe types of sql statements?

558

Why do we use sql constraints?

653

What is loop in pl sql?

565

Is null operator in sql?

598

How do I edit a stored procedure?

551

What is integrity in sql?

549

what is the difference between truncate and delete statement? : Transact sql

536

what is self join and what is the requirement of self join? : Sql dba

677

What is data manipulation language?

690

How do I view a table in sql?

539

What is trigger types of trigger?

548

What is synonyms?

570

Can we insert in view in sql?

559

What is scalar function?

562