> 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?
No Answer is Posted For this Question
Be the First to Post Answer
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
What are group functions in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what are the disadvantages of hierarchial database over RDBMS?
what is the difference between table and veiw?
How to connect to a remote server?
What are the built-in functions used for sending Parameters to forms ?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
How to use in conditions in oracle?
Explain the features of oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?