CODEWITHSUNDEEP
sqloracle-databaseplsql
Rockey
Rockey

Reputation: 33

oracle sql table creation error %s: invalid identifier"

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:

Upvotes: 0

Views: 62

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 522581

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

Upvotes: 1

Related Questions