> 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
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What operating systems are supported by oracle database 10g xe?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to use subqueries in the from clause in oracle?
How to convert csv to table in oracle?
How to concatenate two text values in oracle?
What is meant by joins?
Define the terms primary key foreign key and also the difference between primary and the unique key
what is the exact diiference between DBMS and RDBMS
what are the diffeenes between oracle 9i,oracle 10g
What is a server parameter file in oracle?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.