Please replace "y" with 'y' it will work
----- Original Message -----
From: "RAJALAKSHMI Balasubramanian" <BRajalak@c...>
To: "sql language" <sql_language@p...>
Sent: Wednesday, October 16, 2002 3:59 PM
Subject: [sql_language] Problem in Query


> Hi,
> Can anybody tell me whats the problem with this query?
> CREATE TABLE NEGOTIATN_ENTITY (
>        NEG_ENT_CODE         VARCHAR2(8) NOT NULL,
>        PARENT_CODE          VARCHAR2(5) NULL,
>        CMOD_CODE            VARCHAR2(4) NULL,
>        ACTIVE_FLAG          CHAR(1) DEFAULT "Y" NOT NULL
>                                    CHECK (ACTIVE_FLAG IN ('Y', 'N')),
>        INACTIVE_DATE        DATE NULL,
>        COMMENT_TEXT         VARCHAR2(2000) NULL,
>        CREATE_CODE          VARCHAR2(10) NOT NULL,
>        CREATE_DTS           DATE NOT NULL,
>        UPDATE_CODE          VARCHAR2(10) NOT NULL,
>        UPDATE_DTS           DATE NOT NULL,
>        PRIMARY KEY (NEG_ENT_CODE)
> );
>
> I'm getting an error in default.
>
> Thanx and Regards,
> Raji
>
>