Very Computer

by **Pavel I Babachanak** » Wed, 11 Nov 1998 04:00:00

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

by **Nenad Novelji** » Wed, 11 Nov 1998 04:00:00

> 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

desc table_name

by **Pavel Polca** » Wed, 11 Nov 1998 04:00:00

Hi Pavel,
you can find it in the USER_TAB_COLUMNS Data Dictionary view, the NULLABLE
attribute.

Hth,
Pavel

> 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

by **Andrew Protaso** » Wed, 11 Nov 1998 04:00:00

,

:

x number not null

x number,
constraint table_name_ch_x check(x is not null)

.

> 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

by **Gerard H. Pill** » Wed, 11 Nov 1998 04:00:00

Give all your constraints a name, even the "not null" and "check".
--
Kind Regards,

Gerard

> 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

by **BluesMa** » Thu, 12 Nov 1998 04:00:00

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

> 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