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
- 2037 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What privilege is needed for a user to create indexes in oracle?
How are the index updates?
Is oracle a programming language?
What is oracle in java?
what is difference between where clause and having clause?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
What is difference between cartesian join and cross join?
what is the syntax of ALTER command?
How to pass parameters to procedures in oracle?
What are the differences between lov and list item?
Does oracle charge for java?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
Oracle General 
