Double quotation marks are used when PowerDesigner generates an SQL script for creating a database table.

When PowerDesigner generates an SQL script for database table creation, double quotation marks are used to generate an SQL script for database table creation. Especially for Oracle databases, table names are usually enclosed by quotation marks. In fact, the quotation marks are PL/SQL specifications. The database will strictly follow the name in "" to create a table. If there is no "", the database will create a table according to the default settings of ORACLE (in DBA STUDIO ), by default, all are capitalized. In this way, fields in the ORACLE database are like "Column_1 ". Www.2cto.com if you remove the quotation marks, ORACLE automatically uses uppercase letters ("COLUMN_1") by default. Therefore, this SQL statement is executed in PL/SQL without any problems, if no quotation marks are added, the PL/SQL statements are automatically recognized as uppercase letters. If quotation marks are added, when SQL or hql queries "Column_1 = 'xxx'", an error is reported: ORA-00904: "COLUMN_1": Invalid identifier, unless it is written as 'column _ 1' = 'xxx '". This problem occurs when the script format is generated. Therefore, we can try to modify the corresponding format settings in the DBMS configuration file to solve this problem. For www.2cto.com, select DBMS Properties and Script> SQL> Format. the comment of CaseSensitivityUsingQuote is "Determines if the case sensitiers for identifiers is managed using double quotes ", indicates whether double quotation marks are used to specify the case sensitivity of the identifier. You can see that the default value of values on the right is "YES", change it to "No", and click "Apply.