1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 ?

Question Posted / uma

Answer Posted / uma

The answer will be "else"

declare
L1 number := null;
L2 number :=null;
begin
if L1=L2 then
dbms_output.put_line ('equal');
elsif L1<>L2 then
dbms_output.put_line ('not equal');
else
dbms_output.put_line ('else');
end if;
end;
/

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is primary key? : Sql dba

504

Does truncate release storage space?

548

Who is the owner of mysql database?

545

What is a unique key and primary key and foreign key?

560

What is cross join example?

542




What does where 1/2 mean in sql?

521

What are the dml statements?

680

How to run sql statements through the web interface?

502

what is the difference between $message and $$message? : Sql dba

540

Is delete faster than truncate?

537

What is pl sql script?

558

what is error ora-03113: end-of-file on communication channel?

593

How do I save the results of sql query in a file?

523

What are the two characteristics of a primary key?

481

how can I make a script that can be bi-language (supports english, german)? : Sql dba

530