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
- 2033 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between sid and service name in oracle?
How data locks are respected in oracle?
What are the different type of Segments ?
what diffrence between function and procedure?
How to loop through a cursor variable?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
Explain oracle’s system global area (sga).
What is an Index Segment ?
what is a Nested Loop join?
How to execute a stored procedure in oracle?
Can a parameter be passed to a cursor?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
Oracle General 
