Re: ORA-01400
From: BluesMan <ygrenet_at_club-internet.fr>
Date: Wed, 11 Nov 1998 00:15:51 +0100
Message-ID: <72ahbm$i5k$1_at_front3.grolier.fr>
Date: Wed, 11 Nov 1998 00:15:51 +0100
Message-ID: <72ahbm$i5k$1_at_front3.grolier.fr>
Hi !
- If you have Oracle's SQL*PLUS, the DESC <my_table> command shows you the name, type and null value...
- try this : select * from user_tab_columns where table_name='<MY_TABLE>';
In add, you can use the NVL function to replace null value by other : for instance , NVL(col1,1)=1 if col1 is null....
good luck !, Yann
ygrenet_at_club-internet.fr
Pavel I Babachanakh a écrit dans le message <728ou6$msq$4_at_whale.gu.net>...
> Hi, ALL!
>
> When I INSERT the data into the table which has several
>columns with NOT NULL constraint, I get the following error
>message:
>
>ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
>
> How can I learn which column has NULL value?
>
>Pavel
>uxid_at_artintel.cherkassy.ua
>
>
>
Received on Wed Nov 11 1998 - 00:15:51 CET