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
- 1979 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to experiment a data lock in oracle?
Explain the dml?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What is the maximum number of CHECK constraints that can be defined on a column ?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
Differnce between view and index
What is BBED in Oracle?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What does a Control file Contain ?
What is rowid and rownum in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
Oracle General 
