Question about quotation marks in powerdesigner script generation)

From http://blog.sina.com.cn/s/blog_4fd11d0a0100amb4.html

 

Today, when I used pogen to generate a po for a table I designed using powerdesigner, I started to think that there was a problem with my pogen settings. I checked it several times and felt that there was no problem, so I tried to generate a po file for the previous table, and the result was normal. The problem was caused by a problem in my table.

   The SQL script generated by powerdesigner always prompts "the table or view does not exist" When querying in PL/SQL"

   The SQL query that comes with PL/SQL exists, and the problem is checked because the table and column contain double quotation marks when the script is generated.

 

When you use the powerdesigner script to generate a database, the table name is generally 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 dbastudio ), by default, all fields are capitalized. In this way, the fields in the Oracle database are like "column_1". If you remove the quotation marks, Oracle automatically uses all uppercase values by default, that is, "column_1 ", so don't worry. This SQL statement is executed in PL/SQL without any problems. If no quotation marks are added, it is automatically recognized as uppercase in PL/SQL.

Choose database> edit. Current Database, select SQL-> Format, there is a casesensitivityusingquot E. Its comment is "determines If The Case Sensiti.pdf 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". For example, change the finger direction to "no" and click "OK. Click OK in the pop-up confirmation dialog box.
However, database-> Edit Current I did not find the database option.

 At last, I can only change all the table and field names to uppercase letters.