Strange Oracle error: Identifier too long ORA-00972 Strange Oracle error: Identifier too long ORA-00972 oracle oracle

Strange Oracle error: Identifier too long ORA-00972


You're using the wrong quotes.

VALUES('BreezeMAX MBS',       ^             ^

Demo:

SQL> create table t (a varchar(100));Table created.SQL> insert into t(a) values ("qasdqsdqsdqsdqsdqsdqsdlmqmsldqsmldqsmldq");insert into t(a) values ("qasdqsdqsdqsdqsdqsdqsdlmqmsldqsmldqsmldq")                         *ERROR at line 1:ORA-00972: identifier is too longSQL> insert into t(a) values ('qasdqsdqsdqsdqsdqsdqsdlmqmsldqsmldqsmldq');1 row created.