How to access null values from the table by a query?

vasa · New User Joined: 10 Jan 2006 Posts: 9

How to access null values from the table by a query?
please send me the query.

ragshere · New User Joined: 20 Dec 2004 Posts: 70

vasa,
use this below query as a sample

select * from tablename
where col1 is null

Thanks
Rags

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

Hi,

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project or rows that have null values in PROJECT

SELECT EMPNO
FROM EMP
WHERE PROJECT IS NULL;

The standard to be followed for writing a select st is to give the name of the column to be selected than a '*'.

Thanks,
KS

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

Hi,

Hope am correct abt the standard.If not , kindly correct .

Thanks,
KS

martin9 · Posted: Mon Mar 20, 2006 3:50 pm

hy,

just note:
if you use the INTO variables clause,
you should never forget to give with
the variable also an indicator variable.
because if the value is null and you give no
indicator, your sql statement will abend.

martin9