PowerDesigner using "" double quotes in Oracle build-in statements

Source: Internet
Author: User
Tags powerdesigner

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.