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

Does pdo prevent sql injection?

520

Can we use two order by clause in query?

543

What is the difference between inner join and outer join?

526

What is procedure function?

537

Which is better varchar or nvarchar?

546




What schema means?

522

Do we need to create index on primary key?

463

Can we insert in view in sql?

562

What are primary key and foreign key and how they work?

547

Why do we need cursor in pl sql?

645

Is mariadb a nosql database?

532

what is cursor. write example of it. What are the attributes of cursor.

743

what are the non-standard sql commands supported by 'mysql'? : Sql dba

569

What does inner join mean?

551

What is the most restrictive isolation level? : Transact sql

554