Re: Default Value
Date: Sat, 29 Mar 2008 08:15:14 -0700 (PDT)
On 29 mrt, 15:32, "web.Hunter" <alberto.cerio..._at_gmail.com> wrote:
> Hi, I've a problem with default value of integer data type: my
> software work fine with oracle version 8, but fail with 11g version.
> The problem is on sql insert command because are often omitted some
> columns for use the default value. If the column omitted has a integer
> data type, on oracle 8 the command is succesful executed; viceversa
> the command faild on 11g oracle version: the response message return
> an unexpected null value on a not-null column. I repeat: Only on
> integer data type column.
> I suppose that there is a configuration value that is possible to
> modified but I don't know what and here.
> Best Regards
i'm not sure if i understand your situation correctly. You have a table in oracle 8 that has a default value on one of the columns, and the same table without the default value in oracle 11? Or do both tables have a default value on that column?
select table_name, column_name , data_default from user_tab_columns where table_name = 'YOURTABLE' ;
should return any default value's on columns. To put a default value on a column, you have to use the
alter table YOURTABLE modify (....
and the rest you should know or find in the docs ;)
H. Received on Sat Mar 29 2008 - 10:15:14 CDT