checking and capturing null values and inserting into a tabl

krisna · Post by **krisna** » Fri Oct 17, 2008 4:34 pm

Hi All,

If date column is having null value how to check and then insert (null value with date column) in to a oracle table. Similarly with varchar values also

Thanks in advance

neena · Post by **neena** » Fri Oct 17, 2008 4:46 pm

Try to check with IsNull() function and put '', same with the varchar too.
I may be wrong because I never worked on Oracle.

nsm · Post by **nsm** » Sat Oct 18, 2008 4:53 pm

check with isnull() and then depends on ur logic either insert 'Nothing' or a default date.

For Varchar type columns in addition to checking isnull() also trim the column and do your logic of assigning a value.