Re: 'DESC' as column name

Sorry about from field... :)

Thanks all. Had no idea it was a reserved word. Have changed column name accordingly...

"Mark Wallace" <*CaN NoT HAvE SpaM*@no.spam.man> wrote in message news:dZ4P6.458$3S3.9814_at_news.lhr.globix.net...
> Is 'DESC' (as in a abbr for description) a reserved word for a column
 name?
>
> I successfully create a table with a column called DESC, but as soon as I
> try to add data to the column if get the following error :
>
> 1 INSERT INTO SRC.EVENT_CODES (ID, DESC)
> 2 VALUES
> 3* ('BB', 'BATCH')
> SQL> /
> INSERT INTO SRC.EVENT_CODES (ID, DESC)
> *
> ERROR at line 1:
> ORA-01747: invalid user.table.column, table.column, or column
 specification
>
> The table definitly exist and has a column called DESC as shown below :
> SQL> desc EVENT_CODES;
> Name Null? Type
> ----------------------------------------- -------- ------------
>
> ID NOT NULL VARCHAR2(10)
> NEWD VARCHAR2(30)
> DESC VARCHAR2(10)
>
> Thanks
> Mark
>
>
Received on Thu May 31 2001 - 15:20:41 CDT