Hi,

I got this very interesting issue. I configured a column of a table
defaulted to 'A'. Whenever I insert a record into the table without
specifying a value in that column, the column is not defaulted to 'A'.
I am able to default other char column without any problem. But for
this one column, for some reason, it is not defaulting to 'A'. My
table got 34 columns. There are foreign keys but not set to the column
with the issue. I got a lot of triggers for this table, but i tried
disabling them and inserted a record and still didn't work.


Here is the example. the table and column names are not the actual
names.
-----------
Here are my sql statements.

insert into mytable(id, name)
values(33, 'testme')

select id, name, status
from mytable
where name = 'testme'
-----------
Here is the table definition.

create table mytable
(
id NUMBER(10) not null,
name VARCHAR2(60) not null,
status CHAR(1) default 'A'
)
-----------


Any help is greatly appreciated. thanks
Baldwin