| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01400
Привет,
Сильно рекомендую поменять во всех таблицах анонимные констрейнты на именованные: 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
> uxid_at_artintel.cherkassy.ua
Received on Tue Nov 10 1998 - 03:12:13 CST
 |
 |