Answer Posted / sathish kumar

i stands for internet. from 8i , 9i onwords oracle supports
internet applications.( webbased applications like
ERP,SAP,Oracle.). we can run the java application through
oracle. oracle built in with this software from 8i onwords.
in 10g 'g' stands for grid computing.

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

1983

---

What are the uses of synonyms?

1085

---

What is ceil and floor in oracle?

1011

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1058

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1080

---

What is raw datatype?

1081

---

Please explain compound trigger in oracle?

996

---

Explain the use of online redo log files in oracle.

993

---

How does Oracle guarantee data integrity of data changes?

2333

---

How to change system global area (sga) in oracle?

960

---

how to make an oracle object

2292

---

How to store pictures on to the database?

923

---

What is oracle data type?

903

---

What is a tns service name?

945

---

What are the differences between lov and list item?

992

---