PowerDesigner links Oracle to generate SQL statements

1. Configure link information

Open PowerDesigner and click Database ---> Configure Connections in the main menu to select Connection Profiles

2. Add a data source. Click Add DataSource in.

3. Click Test Connection to Test whether the Connection is normal.

4. Click Database ---> Connect in the main menu.

5. Click Database ----> Generate DataBase in the main menu. Select Direct Generation in generation type and select the new data source.

6. Click OK to generate an SQL statement.

7. Click Run to add the table amc_base_bbb to Oracle.

Note: 1 The default SQL statement generated by powerdesigner contains drop table... In this way, if the table does not exist in the database, an error will be reported. The following configuration can be used to remove the drop table information.

In the main menu, click Database ---> Generate DataBase. Select Options to remove the Drop table.

2. if the table field name is lower-case, the SQL statement generated by Powerdesigner will add quotation marks before each lower-case letter. How can this problem be solved, remove the quotation marks in the automatically generated SQL statement in PowerDesigner.

If an Error occurs when PowerDesigner connects to the database: Non SQL Error: cocould not load class
Solution: copy the required jar package to the PD installation directory before the PD starts, so that the PD can find the required jar package.