how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
Answer Posted / 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 |
Post New Answer View All Answers
What is the disadvantage of User defind function?
what are bitmap indexes? How does they work?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to define a specific record type?
What is oracle datasource?
What is the data pump export utility?
what is IDE,DMV in sql server?
How to do clean up if create database failed?
How to create lov dynamically at runtime & attach to text field?
State some uses of redo log files?
How to install oracle database 10g xe?
What is the difference between 10g OEM and 11g OEM?
Is oracle a relational database?
what is dynamic SGA and static SGA
What are the different types of modules in oracle forms?