How to write a query with a full outer join in oracle?



How to write a query with a full outer join in oracle?..

Answer / guest

select * from t1 full outer join t2

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  


What is user managed backup in Oracle?

0 Answers   MCN Solutions,


What happens to the current transaction if a ddl statement is executed?

0 Answers  


The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,


How to add another datafile to a tablespace?

0 Answers  






Explain a data segment?

0 Answers  


what is the syntax of UPDATE command?

8 Answers  


Why do you use stored procedures and state some of its disadvantages?

0 Answers  


Can you create a synonym without having a table?

0 Answers  


What are the types of synonyms?

1 Answers  


how to create a new database in oracle?

6 Answers   TCS,


Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

2 Answers   Oracle, SAH,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)