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...

What is the result, when NULL is compared with NULL?

Answer Posted / archana

begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;

now it will return null
it is recommended to use 'is' with null not ' ='

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how does a local variable is defined using t-sql? : Transact sql

998


what is a trigger in mysql? : Sql dba

1139


Which certification is best for sql?

981


how to use case expression? : Sql dba

1014


What are the types of records?

988


Why do you partition data?

1016


What is the difference between microsoft access and sql?

1012


what is the difference between a having clause and a where clause? : Sql dba

1073


What is the current version of postgresql?

1056


How can check sql version from command line?

1077


what is schema? : Sql dba

1044


Does truncate require commit?

963


How do I enable sql encryption?

1019


What is lookup table in sql?

1033


What is the limitation on the block size of pl/sql?

980