> 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
- 1834 Views
- I also Faced
- E-Mail Answers
How to resolve the ORA-39133 error in Oracle?
Explain can a view based on another view?
Whether any commands are used for months calculation? If so, what are they?
How can you Enforce Referential Integrity in snapshots ?
Give the Types of modules in a form?
How to assign a table row to a record variable?
What is a read write transaction in oracle?
How to retrieve values from data fields in record variables?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Why does Oracle not permit the use of PCTUSED with indexes?
How to store only time; not date and time?
how to find the second highest salary in a given table????
Oracle General 
