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