Interested to Buy Any Domain ? << Click Here >> for more details...
What is execute immediate in oracle?
- 0 Answers
- 995 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How are the index updates?
How to count duplicated values in a column in oracle?
What is the usage of save points in oracle database?
What is the difference between Outer join and Full outer join?
7. Repeat query (7) but also display all clients who have never ordered anything.
What are the differences between char and varchar2 in oracle?
 How to use an oracle sequence generator in a mapping?
What is the maximum number of triggers that can be applied to a single table?
What is the quickest way to fetch the data from a table?
> 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?
What are the different types of database objects?
Describe the types of sub query?
Oracle General 
