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
How to manage transaction isolation level?
What is recovery manager in Oracle?
How to use group functions in the select clause using oracle?
Where is the export dump file located?
How to get execution statistics reports on query statements?
What is control file used for?
What is a cognitive schema?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is an oracle cursor variable?
How to use windows user to connect to the server?
Explain the use of grant option in imp command.
What is the difference between count (*), count (expression), count (distinct expression)?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is oracle used for?
Explain an exception and its types?