The Oracle table name generated by powerdesigner is enclosed by quotation marks.

Source: Internet
Author: User
Tags powerdesigner

 

The name of the table generated by powerdesigner is enclosed in quotation marks as follows:

/* ===================================================== ======================================= */
/* Table: "eppd_ B _bill_intercalate "*/
/* ===================================================== ======================================= */

Create Table "eppd_ B _bill_intercalate "(
Material_price_id varchar2 (32) not null,
Constraint pk_eppd_ B _bill_intercalate primary key (material_price_id)
)
/

Comment on column "eppd_ B _bill_intercalate". material_price_id is
'Material price ID (cljgmcid )'
/

 

That is, the table name is changed to the expected table name eppd_ B _bill_intercalate plus quotation marks "eppd_ B _bill_intercalate"

 

The main cause of this problem is that the corresponding PDM file contains lowercase letters in the corresponding table name, and Oracle should be uppercase letters by default, so it will be marked with quotation marks. For example, if the name of the table in PDM is "eppd_ B _bill_intercalate", ill is lowercase.

There are two solutions:

First, replace all the table names with uppercase letters, and change ill to eppd_ B _bill_intercalate.

The second is that it takes a long time to change a large number of tables of this type. You can consider canceling the default identifier. The cancellation method is

Select database-> edit current database and select SQL-> Format. There is a casesensitivityusingquote. 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" and changed to "no". Click "OK. In the displayed dialog box, click OK. In this way, the script is generated again after saving, and no quotation marks are generated.

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.