Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 / guest

Answers were Sorted based on User's Feedback



declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

Answer / anil kumar jampana

else
bz, null is an undefined value

Is This Answer Correct ?    8 Yes 0 No

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

Answer / roopesh kumar

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

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

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

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

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

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

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

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

Answer / ramesh

compilation error, because you should not use two times end
if;

Is This Answer Correct ?    3 Yes 5 No

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal&..

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

Post New Answer

More SQL PLSQL Interview Questions

Name some usages of database trigger?

0 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

What does where 1/2 mean in sql?

0 Answers  

Is it possible for a table to have more than one foreign key?

0 Answers  

How subquery works in sql?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

What is linq to sql?

0 Answers  

Where the sql database files are stored?

0 Answers  

What is the difference between the implicit and explicit cursors?

0 Answers  

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

What is a column in a table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories