Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> 'DESC' as column name

'DESC' as column name

From: Mark Wallace <SpaM*_at_no.spam.man>
Date: Thu, 24 May 2001 11:00:37 +0100
Message-ID: <dZ4P6.458$3S3.9814@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 24 2001 - 05:00:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US