Re: ORA-01400

Hi !

1. If you have Oracle's SQL*PLUS, the DESC <my_table> command shows you the name, type and null value...
2. 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 <728ou0$msq$2_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 Tue Nov 10 1998 - 17:15:26 CST