oracle sql table creation error %s: invalid identifier"

Question

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:

An identifier (the column name) can't start with a digit. (Unless delimited as "01_ITEM", but I'd chose another column name.) — jarlh
– jarlh, Commented Sep 14, 2021 at 7:45

Tim Biegeleisen · Accepted Answer · 2021-09-14 07:45:00Z

1

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));

answered Sep 14, 2021 at 7:45

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

astentx Over a year ago

It should be noted, that quotes not only allow additional characters inside the identifier, but also keeps identifier's case.

Collectives™ on Stack Overflow

oracle sql table creation error %s: invalid identifier"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related