Hi Savita,
--On Dienstag, 26. November 2002 16:02 +0530 Savita <savita(at)india(dot)hp(dot)com>
wrote:
> Hi,
> I am able to insert the null field using \N in the text file,but while
> retiving the data I am not able to retrive it.
>
> After inserting data I tried this select statement
>
> select * from os_customer_master where updated_by=' ';
> and
> select * from os_customer_master where updated_by=null;
>
> but it gives 0 rows.then how will I select this values.
Nothing to do with copy :)
Just try:
select * from os_customer_master where isnull updated_by;
Regards
Tino