how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
Answer Posted / 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 |
Post New Answer View All Answers
Is oracle an open source?
Explain overloading. Can functions be overloaded?
What is bulk copy or bcp in oracle?
What are the ways tablespaces can be managed and how do they differ?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is pragma autonomous transaction in oracle?
What is a dynamic performance view in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
what is a Nested Loop join?
What is recovery manager in Oracle?
How to assign a tablespace to a users in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are the advantages of oracle 12c?
What are the differences between lov and list item?
What is an oracle cursor variable?