Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 'DESC' as column name
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)
*
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
![]() |
![]() |