> 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  

---

Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,

---

How can you merge two tables in oracle?

0 Answers  

---

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.

1 Answers   MasterCard,

---

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

0 Answers  

---

---

State the difference between a primary key and foreign key?

0 Answers  

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

Why do we need oracle client?

0 Answers  

---

Can we write dml statement in function in oracle?

0 Answers  

---

difference between bind variable and variable

1 Answers   Attra,

---

what are views?

8 Answers   TCS,

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

0 Answers   Intelligroup,

---