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
>ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
> How can I learn which column has NULL value?