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

What are joins, explain all types of joins?

0 Answers   Bravura Solutions,


How to create a new tablespace in oracle?

0 Answers  


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

0 Answers   Oracle,


What are the different type of Segments ?

2 Answers  


What are the database administrators utilities available?

0 Answers  






What are the ways tablespaces can be managed and how do they differ?

0 Answers  


What is data file?

0 Answers  


how to insert the image in table

2 Answers  


What is null value in oracle?

0 Answers  


what are the database links ?

2 Answers  


What is BBED in Oracle?

0 Answers   MCN Solutions,


How to sort the query output in oracle?

0 Answers  


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)