After the data model is created in powerdesigner and connect to Oracle9i, the created table is displayed in the oralce management tool. However, when you use the SELECT command to query the table, the table name does not exist.
You can use the select * From tab command to query and find that the clusterid In the table displays a combination of uppercase and lowercase table names.
The possible cause is that PowerBuilder designs the table name, column name, and related objects directly created in Oracle.
The display case. After the SELECT command is used in sqlplus, the names not enclosed in double quotation marks are converted into uppercase letters.
In this way, the table name cannot be found.
Solution:
Change the code of all naming convention to uppercase in model options of tools in powerdesigner. In this way, all objects are capitalized when SQL statement is generated.
Done. Thanks to Han ge.