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 OceanBase Developer Center (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. |