Home > Back-end >  oracle sql table creation error %s: invalid identifier"
oracle sql table creation error %s: invalid identifier"

Time:09-16

Any idea why I am getting the below error while creating table on Oracle DB ?

SQL

create table tst(01_ITEM varchar2(100) );

Error Error report -

ORA-00904: : invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:

CodePudding user response:

Oracle database object names cannot begin with a digit. You should avoid creating such column names. If you must do this, then escape the column name using double quotes:

CREATE TABLE tst ("01_ITEM" varchar2(100));
  • Related