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


Please Help Members By Posting Answers For Below Questions

What is user managed backup in Oracle?

824


What are the different types of synonyms?

815


How to get a create statement for an existing table?

735


How to handle a single quote in oracle sql?

781


How to estimate disk space needed for an export job?

752


What are the tools for Oracle ?

798


How to resolve the ORA-39133 error in Oracle?

790


How are extents allocated to a segment?

771


How to get maxsal , minsal, ename department wise in single query

1293


What are the roles of dba?

788


What are the uses of linked server and explain it in detail?

803


How to work with data objects interactively?

716


How to call a stored function in oracle?

741


How to upsert (update or insert into a table)?

730


What is a data lock in oracle?

792