ODC allows you to customize the SQL development interface and some collaboration features.
Procedure
Log in to the ODC console and click Settings in the lower-left corner to go to the user settings page. Configure the personal user settings and team workspace settings as needed.
User
| Type | Configuration item | Description |
|---|---|---|
| Session | MySQL Commit Mode | The default transaction commit mode in MySQL mode. |
| Session | Oracle Commit Mode | The default transaction commit mode in Oracle mode. |
| Result Set | Get Column Info | Specifies whether to enable column information retrieval before executing an SQL statement. If you disable this option, column comments and editable column information will not be queried, thereby reducing SQL execution time when the table contains a large number of columns. |
| Result Set | Get Row ID | Specifies whether to enable row ID retrieval. |
| SQL Execution | Enable Full-Chain Tracing | Specifies whether to enable full-chain tracing during SQL execution. |
| SQL Execution | Continue Execution on Error | Specifies whether to continue SQL execution when an error occurs. |
| SQL Execution | Delimiter | Specifies the delimiter of an SQL statement. |
| Object | Drag-and-Drop Statement Type | Specifies the type of SQL statements to be automatically generated when you drag and drop a database object (such as a table or view) to the editing area. |
| Style | Theme | The theme of the editor, including OceanBase, VSCode, and GitHub. |
| Style | Font Size | The font size of the editor, which can be small, normal, or large. |
| Shortcut | Run SQL | Specifies the shortcut key for running all SQL statements. |
| Shortcut | Run Selected SQL | Specifies the shortcut key for running the selected SQL statement. |
| Theme | - | The theme color of the page. |
| Workspace | Default workspace | Specifies whether to display the team workspace or personal workspace by default after you log in. |
| Privacy | User Behavior Analysis | Specifies whether to enable user behavior analysis. |
Team workspace
| Type | Configuration item | Description |
|---|---|---|
| SQL Query | Maximum Number of Query Results | The maximum number of query results. The default value is the maximum number of query results specified in the metadata database. You can reduce this value. |
| SQL Query | Default Number of Query Results | The default value is 1000, which cannot exceed the maximum number of query results. If the maximum number of query results is less than 1000, the default value is the maximum number of query results. |
| Ticket Task | Allow Structure Replacement During Data Import | Specifies whether to allow direct replacement of existing structures (such as tables and views) when a table or object with the same name already exists in the target database during data or database structure import. |
| Ticket Task | Generate Backup Rollback Plan by Default | Specifies whether to generate a backup rollback plan by default when a database is changed. |
| Ticket Task | Allow Viewing and Downloading Query Results in Database Change Tickets | Specifies whether to allow viewing and downloading query results in a database change ticket. |
| Ticket Task | Default Execution Mode for Database Change Tickets | Specifies the default execution mode for database change tickets. |
| Ticket Task | Task Description Prompt | Specifies the prompt text to be displayed when you submit a ticket. The prompt text can be up to 200 characters. |
| Security | Data Source Key | Specifies the key of the data source. |