> 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  

---

how can we write trigger in trigger???????? can we write one trigger on two table???

2 Answers   Value Labs,

---

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.

11 Answers   Wipro,

---

what are steps for interface? where is exchange rate defined in which table?

0 Answers  

---

what is kernel?

2 Answers   Microsoft,

---

---

How to drop a stored procedure in oracle?

0 Answers  

---

what is the use of composite key constraint?

2 Answers  

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

0 Answers  

---

how to find out second largest value in the table

8 Answers  

---

How to use fetch statement in a loop?

0 Answers  

---

Explain about integrity constraint?

0 Answers  

---

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

---