Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 7 Answers
- 14617 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
In term of oracle block should be like as........
SQL> declare
2 l1 number := null;
3 l2 number :=null;
4 begin
5 if l1=l2 then
6 dbms_output.put_line ('equal');
7 elsif l1<>l2 then
8 dbms_output.put_line ('not equal');
9 else
10 dbms_output.put_line ('else');
11 end if;
12 end;
13 /
else
PL/SQL procedure successfully completed.
Answer is as shown at end of block ELSE.
because u can't compare a null value to other null.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / sdp
The message() function has not been declared in the block.
If it would have been declared then answer would be 'ELSE'
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / ramesh
compilation error, because you should not use two times end
if;
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / arup ratan banerjee
The answer will be "not equal"
because when two null values are compared then it Returns
False.
| Is This Answer Correct ? | 1 Yes | 8 No |
How many times can we commit in a loop?
What are the parts of a basic sql query?
How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
What is the difference between left join and right join?
What is schema in sql example?
How do I trace sql profiler?
What is the syntax to add a record to a table?
What are different categories of sql commands?
How many scalar data types are supported in pl/sql?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
Types of locks in database ?
Can we join more than 2 tables in sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
