Interested to Buy Any Domain ? << Click Here >> for more details...
How to execute the package in oracle?
- 0 Answers
- 1083 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
Hi Can any one tell me what are the API's used in requisition import.
How to use select statement to count the number of rows in oracle?
how to get second highest sal of emp table
What is SAVE POINT ?
What is a subquery?
What's dateware house and what's clustor with practicle example
What is a initialization parameter file in oracle?
What is merge in oracle?
What are the execution control statements?
Why cursor variables are easier to use than cursors?
> 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?
Oracle General 
