What are all the different ways available to find the null value in a table

NSingh

 Profile Answers by NSingh Questions by NSingh

• May 22nd, 2010

select * from tab_namewhere col_name is null

psingla

 Profile Answers by psingla Questions by psingla

• May 6th, 2010

In pl/sql:"is null" and "is not null" are the best way to find null and not null values resp.In t-sqlif ansi_nulls is off then(set ansi_nulls off)"=" will work to search the null values

Answer Question  Select Best Answer