Interested to Buy Any Domain ? << Click Here >> for more details...
how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 9170 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
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 are the differences between number and binary_float in oracle?
what happened to the global index when I truncate the data in one of the partition?
How do I escape a reserved word in oracle?
Is java required for oracle client?
How to use "startup" command to start default instance?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is an index associated with a constraint?
How to use like conditions in oracle?
What is difference between sid and service name in oracle?
What are the differences between char and varchar2 in oracle?
How many types of tables are there in oracle?
How to drop a tablespace?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the disadvantage of User defind function?
