how many outer joins are used in a single sql query? is
there any limitations for using of outer joins?
- 2 Answers
- 7885 Views
- BOB Technologies, Cap Gemini, IBM, I also Faced
- E-Mail Answers
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
How to compare dates in oracle sql?
How to store pictures on to the database?
What happens if you set the sga too low in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
What are the differences between lov and list item?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to call a sub procedure?
How to drop an existing view in oracle?
How to drop an existing table in oracle?
What is oracle host variable?
How to write a left outer join with the where clause in oracle?
 What are the oracle DML commands possible through an update strategy?
What are group functions in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to use "in" parameter properly?
