OceanBase Developer Center (ODC) allows you to customize some features for SQL development windows and team collaboration windows.
Procedure
Log on to the ODC console, and click Settings in the lower-left corner to go to the user settings page. Configure the settings for your individual or team workspace as needed.
User workspace settings
Type | Parameter | Description |
Session | MySQL Commit Mode | Specifies the default transaction commit mode in MySQL-compatible mode. |
Session | Oracle Commit Mode | Specifies the default transaction commit mode in Oracle-compatible mode. |
Result Set | Obtain Result Set Column Information | Specifies whether to retrieve the result set column information. You can set this parameter before SQL execution. If the table contains a large number of columns, we recommend that you disable this option. After you disable this option, column comments and editable columns are not queried, which shortens the SQL execution time. |
Result Set | Obtain Row ID | Specifies whether to retrieve the row ID. |
SQL Execution | Enable End-to-end Diagnostics | Specifies whether to enable end-to-end tracing for SQL execution. |
SQL Execution | Continue Execution on Error | Specifies whether to continue executing SQL statements when an error occurs. |
SQL Execution | Delimiter | Specifies the delimiter for SQL statements. |
Object | Type of Statement Generated Using Object Drag-and-Drop | Specifies the type of SQL statements automatically generated by dragging tables, views, or other database objects to the editing area. |
Style | Theme | Specifies the theme of the editor, such as OceanBase, VSCode, and GitHub. |
Style | Font Size | Specifies the font size of the editor. Supported options are small, normal, and large. |
Shortcuts | Run SQL | Specifies the shortcut keys to run all current SQL statements. |
Shortcuts | Run Selected SQL | Specifies the shortcut keys to run the selected SQL statements. |
Theme | - | Specifies the color palette of the theme. |
Workspace | Default Workspace | Specifies whether to display the team workspace or individual workspace after logon. |
Privacy | User Behavior Analysis | Specifies whether to enable user behavior analysis. |
Team workspace settings
Type | Parameter | Description |
SQL Query | Maximum Entries per Query | By default, the maximum number of entries per query is set to that for the MetaDB, which is dynamically configured. This is to be compatible with historical data. You can reduce the maximum number as needed. |
SQL Query | Default Entries per Query | The value cannot exceed the maximum number of entries per query. Default value: 1000. If the maximum number of entries per query is less than 1,000, that value is used as the default. |
Tickets | Allow Schema Substitution for Import Tickets | Specifies whether to directly replace the existing schema, such as tables and views, during data or database schema import when the target database already contains a table or object with the same name. |
Tickets | Automatically Generate Backup Rollback Plan for Database Changes | Specifies whether to automatically generate a backup rollback plan when database changes are made. |
Tickets | Query Results of Database Changes | Specifies whether to support viewing and downloading query results in database change tickets. |
Tickets | Default Execution Mode of Database Changes | Specifies the default execution method when a database change ticket is created. |
Tickets | Task Description Prompt | Specifies the predefined prompt text displayed to guide users in filling out the task description when creating a ticket. The description cannot exceed 200 characters. |
Security Settings | Data Source Access Key | Specifies the access key for the data source. |