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
- 9302 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 |
What is a Data Dictionary ?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
How to start a specific oracle instance?
What are the restrictions in a oracle read only transaction?
1) Does oracle have any table which contain all the exceptions and it's code internally?
waht is referencial integrity?
How to find the date and time of last updated table?
what is load balancing and what u have used to do this?(sql loader)
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain coalesce function?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Oracle General 
