Answer Posted / mahima

use @@rowcount

how to make an oracle object

1848

---

What is Segment Advisor in Oracle?

659

---

> 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?

1561

---

How to run the anonymous block again?

588

---

What are the built-in functions used for sending Parameters to forms ?

2835

---

---

How to rebuild an index in oracle?

543

---

Can sub procedure/function be called recursively?

525

---

How to create a single index for multiple columns?

552

---

How to invoke the original export import utilities?

496

---

How a database is related to tablespaces?

570

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1604

---

How to convert times to characters in oracle?

595

---

Explain the use of inctype option in exp command.

585

---

How to convert raw data type into text in oracle? Explain

595

---

What is a package ? What are the advantages of package ?

589

---