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 to add new employee details in an employee_details table with the following details

1091


Can we write dml inside a function in sql server?

947


Can a trigger call a stored procedure?

1070


What is server name sql?

1143


When should I use nosql database?

1006


Is coalesce faster than isnull?

966


Explain character-manipulation functions?

1131


What is primary and foreign key?

1062


What is sql query limit?

975


what is msql? : Sql dba

988


What is nosql db?

966


Is a view faster than a stored procedure?

969


What is data type in database?

992


How do I remove all records from a table?

1072


How do I use google cloud in sql?

1084