The administrator can configure global settings on the System Settings page. Other users can configure the same features on the Personal Settings page. The personal settings have a higher priority than the system settings configured by the administrator.
Log on to ODC as the administrator, and go to the Public Resource Console page. In the left-side navigation pane, click the System Settings to display the System Settings page on the right.
In the upper-right corner of the page, click Edit to edit the settings. The following table shows settings that you can configure.
| Field | Description |
|---|---|
| Session Mode for SQL Window | Set the session mode of the SQL window. |
| Delimiter Settings | Set the default delimiter for executing PL statements in the SQL window. Five types of delimiters are supported: semi-colons ( ; ), slashes ( / ), double slashes ( // ), dollar signs ( $ ), and double dollar signs ( $$ ). |
| Transaction Commit Mode in Oracle Mode | Set the default transaction commit mode in Oracle mode. Valid values: Manual and Automatic. |
| Transaction Commit Mode in MySQL Mode | Set the default transaction commit mode in MySQL mode. Valid values: Manual and Automatic. |
| Maximum Number of Rows in Result Set | Set the default number of rows returned for an SQL statement executed in the SQL window. |
| Type of Statements Generated by Dragging and Dropping Object | Set the default type of statements generated when you drag and drop table or view objects. |