What is an anonymous block?

1155

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

1980

What are the benefits of ordbms?

1024

What happens to the data files if a tablespace is dropped?

994

How would you change old and new values in an insert, delete and update triggers?

950

How can I create database in oracle?

959

How to synchronize 2 schema's objects?

2114

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2045

What is sequence?

1008

definition of cluster and non-clustered index?

2959

What is the difference between sharding and partitioning?

928

What is transport network substrate (tns) in oracle?

991

what is the difference between data migration and production migration.

2274

What are data pump export and import modes?

1015

Is oracle an operator?

883