Remove the quotation marks from the field names in the PowerDesigner generated SQL script

When you use PowerDesigner to generate a database to build a table SQL script, especially when the Oracle database is used, the table name is typically quoted. In fact, the quotation marks are PL/SQL specifications, the database will be strictly in accordance with the name of "" to build a table, if not ", will be based on the default set of Oracle Table (Dbastudio), the default is all uppercase, so that in the Oracle database fields such as" column_1 ". If you remove the quotation marks, Oracle automatically defaults to all caps , which is "column_1", so there is no problem when this SQL is executed in PL/E, and is automatically recognized as uppercase if not quoted. If the quotation marks, SQL or HQL query "column_1= ' XXX '", will be error: ORA-00904: "column_1": invalid identifier, unless written as "' column_1 ' = ' xxx '". This issue is a question of generating a script format, so we can try to fix the problem by modifying the appropriate formatting in the DBMS configuration file. Select the DBMS Properties, select Script->sql->format, and have a casesensitivityusingquote that comment "determines if the case Sensitivity for identifiers is managed using double quotes ", which indicates whether the quotation marks are applied to specify the case of the identifier, you can see that the values on the right have the default value" YES "and" No ", click" Apply " Button.

Reference turn: http://www.cnblogs.com/zwq194/archive/2012/09/21/2697033.html

Remove the quotation marks from the field names in the PowerDesigner generated SQL script