DSXchange

Posted: **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

Posted: **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.

Posted: **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.

DSXchange

checking and capturing null values and inserting into a tabl

checking and capturing null values and inserting into a tabl