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 / 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
Explain the insert into statements in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is delete command in sql?
How do I run a pl sql procedure in sql developer?
How many rows can sqlite handle?
Can pl sql procedure have a return statement?
What is not equal in sql?
What do you mean by rowid?
Is truncate ddl or dml?
what is 'mysqladmin' in mysql? : Sql dba
How can we make an if statement within a select statement?
What is PL/SQL Records?
Can we use insert statement in function?
Explain the working of primary key?
what does it mean to have quoted_identifier on? : Sql dba