> 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
- 1818 Views
- I also Faced
- E-Mail Answers
how to find the second highest salary in a given table????
How to create a stored program unit?
What is rich query?
Please explain drop constraint oracle?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
What is a Segment ?
What is a system tablespace?
Explain the function of optimizer in oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to download oracle database 10g xe?
How to define an anonymous procedure without variables?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Oracle General 
