Re: ORA-01400

From: <mpir_at_compuserve.com>
Date: Fri, 13 Nov 1998 13:49:13 GMT
Message-ID: <72hdcp$2n0$1@nnrp1.dejanews.com>

Inserts are positional.

If you are doing 'insert into fred

                 values (1,2,,4)'

value 3 is the not nullable
or

    insert into fred(a,b,c,d)
    values(1,2,3,4)

there are 5 columns in the table and value 5 is not nullable

In article <72ah3v$gsu$1_at_front3.grolier.fr>,   "BluesMan" <ygrenet_at_club-internet.fr> wrote:
> 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 <728ou2$msq$3_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
> >
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 07:49:13 CST