What is a named program unit?

1082

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4594

What is connection pooling in oracle?

973

What is oracle datasource?

984

How do I escape a reserved word in oracle?

1198

How to create a server parameter file?

1135

How to execute a stored program unit?

1074

What is data file?

1104

What are the different editions of oracle?

1108

What are the different types of record groups in oracle? Explain each of them

1025

How to check database size in Oracle?

1191

What is enter substitution variable in oracle?

1052

How to turn on or off recycle bin for the session?

1109

How do we represent comments in oracle?

1048

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

2030