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
What is a tns service name?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do we create privileges in oracle?
What is ASM (Automatic Storage Management) in Oracle?
How to define a procedure inside another procedure?
Difference between oracle's plus (+) notation and ansi join notation?
How can we delete duplicate rows in a table?
What is oracle latest version?
How to convert a date to char in oracle? Give one example.
how to join query for one source type is oracle another source type is sql server ?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to use "if" statements on multiple conditions?
How can we find out the current date and time in oracle?
What is a read only transaction in oracle?
Can you create a synonym without having a table?