For Oracle database, when using PowerDesigner tool (or Navicat tool) to write database script, sometimes the column name is quoted in double quotation marks when creating a table

java an error will be reported when connecting ora-00904 : the identifier is invalid; If you remove the double quotation marks, you won’t report an error

For example:

Original table:

1 CREATE TABLE ”my_test“(
2   “id” NUMBER(10) NOT NULL, 
3   ”name“ VARCHAR2(20) NOT NULL, 
4   “password” VARCHAR2(10 CHAR) NOT NULL, 
5   PRIMARY KEY (ID)
6 )

After modification:

1 CREATE TABLE my_test(
2   id NUMBER(10,0) NOT NULL ENABLE, 
3   name VARCHAR2(20 CHAR) NOT NULL ENABLE, 
4   password VARCHAR2(10 CHAR) NOT NULL ENABLE, 
5   PRIMARY KEY (ID)
6 )