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
- 2088 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index
How to join two tables in a single query using oracle?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
Explain what are the uses of rollback segment?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
what is Table ?
Draw E-R diagram for many to many relationship ?
types of indexes and the rationale behind choosing a particular index for a situation.
How to delete a column in an existing table in oracle?
Where do we use decode and case statements?
IS it possible to built the oracle database without setting the kernal parameters?
What a SELECT FOR UPDATE cursor represent.?
Oracle General 
