how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?

Answers were Sorted based on User's Feedback



how many outer joins are used in a single sql query? is there any limitations for using of outer jo..

Answer / girija.112

ANS:
Only one outer join is possible for a single query & it can be
either left outer join or right outer join or full outer join.
We can't use two outer joins for a single query.

Is This Answer Correct ?    17 Yes 5 No

how many outer joins are used in a single sql query? is there any limitations for using of outer jo..

Answer / jaya krishna goud

the above answer is valid if we use consider only 2 tables .

Q) How many outer joins we can have for a query considering
more number of tables( eg:5 tables ..?)

Thank U ...

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,


How many memory layers are in the shared pool?

1 Answers  


What is bulk collect in oracle?

0 Answers  


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  


What is a subquery?

0 Answers  


What is using clause and give example?

0 Answers  


how may join possible between (requisition with purchase order)

0 Answers  


How to update values in a table in oracle?

0 Answers  


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers   Oracle,


Explain an index segment?

0 Answers  


How is it different from a normal table?

0 Answers  


what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)