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
- 14601 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 to run sql*plus commands in sql developer?
Can a view be mutating? If yes, then how?
what is rdbms? : Sql dba
What is data abstraction in sql?
Differentiate between sga and pga.
State few characteristics of pl/sql?
How many unique keys can a table have?
What is error ora-01000: maximum open cursors exceeded
What is a function in oracle pl sql?
Explain aggregate functions are available there in sql?
What are the types of variable use in pl sql?
How many levels can subqueries be nested in a FROM clause?
-
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)
