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
- 9300 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Explain parameter file in oracle.
How do I uninstall oracle client from windows?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What are the restrictions on external table columns?
How do I call oracle stored procedures that take no parameters?
how many types of index?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
When system tablespace is created?
How to define a cusotmer as a supplier in ORACLE R12
How can we view last record added to a table?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Oracle General 
