Answer Posted / amit basu
pragma is a complier directive.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to do a full database export?
Why is oracle database so popular?
Is oracle an open source?
What to do if dba lost the system password?
Explain the use of consistent option in exp command.
Why is oracle so popular?
How to export several tables together?
Does oracle charge for java?
What is bind variable in oracle 11g?
Why do we use coalesce function in oracle?
What are the differences between primary key and unique key?
Can you have more than one content canvas view attached with a window ?
What are the uses of synonyms?
> 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?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?