Interested to Buy Any Domain ? << Click Here >> for more details...
how to clone 9i Database on to 10g Database.
- 0 Answers
- 2284 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is Data Dictionary Cache in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
what is the difference between substr and instr function in oracle?
What are the most common interview questions on ETL Testing for experience?
How to define a record variable to store a table row?
Explain the features of oracle?
How to end the current transaction in oracle?
What is user managed backup in Oracle?
Does oracle database need java?
> 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?
Can we call procedure inside function in oracle?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
Oracle General 
