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
- 2090 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
what is unique key?
14 Answers Amazon, Cap Gemini, Infosys, Wipro,
Point out the difference between user tables and data dictionary?
difference between oracle8i and oracle9i
What is a dead lock in oracle?
What is clustered table in Oracle?
What is dictionary cache ?
What is Hash Index?
how to we delete a row using varray
Can anyone give me information about oracle certification
What are the restrictions in a oracle read only transaction?
What are advantages of dateset in datastage?
Oracle General 
