The issue of double quotation marks for Oracle data code generated by PD __oracle

Today we made a few tables with PD11, and after generating the Oracle code, inserting data after importing to the database is always an error. Depressed for a long time, on the Internet to check the data, said to be the PD generated code in the table name, the field name has double quotes, a look at the code, sure enough. Look at the things on the Internet The reason, is my table name, Field name I use lowercase letters, if you use capital letters is not a problem. No way, because too many fields, I directly in Notepad will double quotes all replaced. Problem solving.

Here are some of the information I found on the internet about PD and Oracle, interested to see!

Considerations for PD Design Oracle Database

1. Table names and field names are best used in uppercase letters, and lowercase letters can be used, but you must add double quotes on both sides when you use them.

2. When creating tables and fields, it is best to add comment information, which is included in the generated SQL script.

3. The maximum length of the table name and field name is 30 bits, and if the name is too long, check MODEL,PD will be a direct error when generating the database script.

4. If the primary key of the table is implemented using a sequence, the name of each table's primary key is best not the same, because in the case of a reference relationship in PD, the system uses fields to add foreign keys to the field. When I started doing it. The name of the primary key is called ID, and the result is that when the physical model is generated from the conceptual model, the system discovers the name of the field and automatically generates a field, which is generally unsuitable and needs to be modified.

5. When using PD, domain can be created in the conceptual model, and fields can be directly referenced in the creation of entity. The advantage of this is that PD automatically updates the fields associated with domain when information in domain changes.

6. The field name of the database is best not to use commonly used English words, because it is possible that the Oracle database reserved words. I did it. Two field names are Oracle reserved words, version and comment.