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

How to define an oracle sub procedure?

602


What operating systems are supported by oracle database 10g xe?

584


what is the scenario where you take the database to NoArchivelog mode?

1840


How to define an anonymous procedure with variables?

547


What is SQL Tuning Advisor in Oracle?

635






Explain what are the different type of segments?

580


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1744


what is the difference between data migration and production migration.

1813


What is BBED in Oracle?

689


What are operators in oracle?

532


Explain enable novalidate constraint.

599


Differentiate between pre-select and pre-query?

625


Explain compound trigger in oracle?

553


How can I see all tables in oracle?

545


why dont we assign not null constraint as table level constraint.

2257