These days using PowerDesigner to build a library, general database exported SQL build table statements with "" double quotation marks, resulting in my library table names are lowercase, but the Oracle query and other statements by default are uppercase judgments, so it is inconvenient, Previously using PD did not find this problem, it may be the version of the upgrade caused, checked, the original need for PD to set up a bit:
Two ways 1, PD Edit current dbms-oracle9i2::script\sql\format\casesensitivityusingquote to change the setting of double quotation marks to No
2, the workaround is the general database when the text is set to upper in the options so that the quotation marks inside all become uppercase
Comment Note setting PD in the export tables&views will be the table and columns comment full hook, so that the model when the comment comment can also import library, sometimes lazy to write comment want to use name instead, You can also check the options inside the geneate name in empty COMMENT,PD is still very convenient
PowerDesigner using "" double quotes in Oracle build-in statements