Answer Posted / brahma412

i think procedure does not return any values.
but fuction returns value

How are extents allocated to a segment?

1061

---

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

1979

---

What are the different pseudo commands? Explain in general?

1019

---

what is IDE,DMV in sql server?

2752

---

How many categories of data types?

936

---

Is there a combination of "like" and "in" in sql?

1004

---

How to call a sub procedure?

1034

---

What are privileges and grants?

1002

---

what is the dual table in oracle?

932

---

How to test null values?

1041

---

What is a cursor variable?

1043

---

How to convert dates to characters in oracle?

982

---

What is oracle host variable?

980

---

In the oracle version 9.3.0.5.0, what does each number shows?

1223

---

What do you mean by a deadlock?

1008

---