Answer Posted / anilchauhan85
null value means null it it not equal 0 or space.
if we add,delete,subtract in null then return null.
ex.
1+2+null=null
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to import one table back from a dump file?
6. Display the client name and order date for all orders using the traditional method.
> 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?
What is an oracle transaction?
What is index in Oracle?
Difference between oracle's plus (+) notation and ansi join notation?
How to define a variable of a specific record type?
what are actual and formal parameters?
What is an oracle?
what is normalisation?what are its uses?
What are the ansi data types supported in oracle?
Where is the export dump file located?
How to convert characters to dates in oracle?
How are extents allocated to a segment?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?