External tables are supported. On tab Physical Properties, select the External Table (Organization External) checkbox. The External Table Properties tab will occur on the form.
For Char and Varchar2 data types, you can define Column Length in.
For User data type, you can define REF options.
Note: Change for CHAR/BYTE of attributes: Previously, it was necessary to select CHAR or BYTE for Char(x) and Varchar(x) data types of attribute (domain) in Column Length in combo box. Now there is a new item "Default" that is selected by default.
Used Sequence (trigger) - From this box, you can select a sequence that you want to use for the attribute. (A new trigger will be created in SQL script.)
Encryption Specification - Here, you can write e.g. USING 'AES192' NO SALT.
Example of Expression index:
Example: Index properties (for domain index):
When you select Varray Type or Nested Table Type, a new tab displays (Varray Type tab or Nested Table Type tab). There, you can see new boxes where you write appropriate values. Click Create Definition and the definition will be written in the memobox.
The content of the boxes is not saved and is not used for reverse engineering, script or report generation.
Hints in memoboxes for User Data Types are shown.
Support for Oracle Java Source, including reverse engineering: All the three types of Java schema objects (SOURCE, CLASS, RESOURCE) should be written to this object. - During reverse engineering only SOURCE types are loaded, and from them only sequences of characters for Java source. Other Java schema objects (CLASS, RESOURCE) are loaded only as a name. Checkbox Generate is unselected for all the Java schema objects (SOURCE, CLASS, RESOURCE).
Available Data Providers are:
Connection via ADO:
Connection via TCP/IP
Note: Connection via TCP/IP does not support Oracle native encryption.
What to Generate tab - For Entities and Materialized Views the following checkboxes are available:
Uncheck the Physical Properties checkbox not to generate content of tab Physical Properties of entities and materialized views. (For entities, content of tab External Table Properties will not be generated either.)
Uncheck the Table Properties/ Materialized View Properties checkbox not to generate the content of these tabs in entity and materialized view dialogs.
Virtual Column area - If you want the column to be virtual column, select the Is Virtual Column checkbox and fill out the Expression box (e.g. Attribute2 * Attribute3) and set appropriate data type.
The Trigger Fire box with an item COMPOUND.
Body of Compound Trigger, including initial key sentence "COMPOUND TRIGGER", should be written on tab SQL.
From the Trigger Fire box, you can select items COMPOUND or BEFORE or AFTER.
From the Trigger Fire box, you can select items COMPOUND or INSTEAD OF.