What is the result, when NULL is compared with NULL?
Answer Posted / archana
begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;
now it will return null
it is recommended to use 'is' with null not ' ='
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is cte sql?
Why is sql*loader direct path so fast?
Why do we go for stored procedures?
How to change the order of columns in Oracle SQL Plus ?
What is the use of partition by in sql?
Which is faster union or join?
What is the order of sql select?
What do you understand by pl/sql cursors?
What does rownum mean in sql?
Where the sql database files are stored?
What is a record in pl/sql?
Can a procedure in a package be overloaded?
What are operators available in sql?
Explain cursor types?
describe mysql connection using mysql binary. : Sql dba