Interested to Buy Any Domain ? << Click Here >> for more details...
> 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?
- 0 Answers
- 1989 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
can any one help me with import/export options in oracle............
What is the sid in oracle?
What is Reduced List of Values?
How to run the anonymous block again?
What is null value in oracle?
can we pass two out parameters at a time in function?please answer to my question
What is difference between sid and service name in oracle?
what is the uses of cusor
How to open a cursor variable?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How to define an oracle cursor variable?
Will you be able to store pictures in the database?explain.
Oracle General 
