declare
l1 number := null;
l2 number :=null;
begin
if l1=l2 then message('equal');
else
if l1<>l2 then message('not equal');
else
message('else');
end if;
end if;
end;
What will be the output ?

Answer Posted / subrahmanyam.k

Null is not a charcter,unapplicable and not space. we can't
applicable or compare to another. so the final output is "ELSE"

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ms sql traffic encrypted?

505


Can ddl statements be used in pl/sql?

597


What is raw datatype in sql?

558


What is the unique index?

526


Write a sql query to find the names of employees that begin with ‘a’?

578






What is a dynamic query?

572


Where not exists in sql?

503


What is a recursive join sql?

597


In what condition is it good to disable a trigger?

558


what is an alias command? : Sql dba

551


What are inner and outer joins examples of both?

499


Name the different types of indexes in sql and define them.

570


Which one is better subquery or joins?

557


How can triggers be used for the table auditing?

595


what are different types of collation sensitivity? : Sql dba

561