At 11:51 AM 4/06/2008, you wrote:

>I tried the following also but still got an error.
>
>SQL> create table test(
>CON> my_id varchar(255) character set none default '' not null,
>CON> au_menu varchar(20) character set none default '' not null,
>CON> au_auth char(1) check(value in ('r','w','d')) default 'r' not
>null,

CON> au_auth char(1) default 'r' not null check(value in ('r','w','d')),

FYI, the order is

DEFAULT <default-value>
NOT NULL
<CONSTRAINT DEFINITION>

./heLen