Customizing Data Studio

General

Shortcut Keys

Modify or cancel the shortcut key. You cannot add shortcut keys.

For details about the default shortcut keys, see Customizing Data Studio.

Editor

Syntax Coloring

You can modify the highlight colors of comments, default values, non-reserved keywords, reserved keywords, data types, symbols, constants, and character strings.

SQL History

You can set the number of SQL history records and the number of SQL query characters.

• Number of SQL history records

  Sets the number of queries that can be saved in historical records. After this parameter is modified, the modification takes effect for new queries.

  The value ranges from 1 to 1000. The default value is 50.

• Number of SQL query characters

  Sets the number of characters of the queries saved in the SQL historical records. After this parameter is modified, the modification takes effect for new queries.

  The value ranges from 1 to 1000. The default value is 1000. If the characters are not limited, set the parameter to 0.

Template

Create, edit, or delete the abbreviation template.

Format

Sets the tab width and whether to convert tabs to spaces while performing indenting and un-indenting operation.

Transaction

Whether the automatic commit function is enabled.

• Enable: Transactions are automatically submitted.
• Disable: You need to manually submit or roll back the transaction.

Folding

Whether the SQL folding function is enabled.

Modification only takes effect in a newly opened editor. The editor which is already opened will remain with previous settings until restart.

• Enable: SQL statements can be folded or unfolded.
• Disable: SQL statements cannot be folded or unfolded.

Font

Setting the font.

The value ranges from 1 to 50. The default value is 10.

Auto Suggest

Set the recommended minimum number of characters.

This field indicates the minimum number of characters required to trigger automatic advice when a user enters an SQL statement.

The value ranges from 2 to 10. The default value is 2.

Security

Password

• Whether the Permanently option is displayed in the Save Password drop-down list.
  • Yes: The Permanently option is displayed in the Save Password drop-down list in the connection window.
  • No: The Permanently option is displayed in the Save Password drop-down list in the connection window, and the saved password will be deleted.
• Whether login is allowed after the password expires.
  • Yes: After the password expires, the user can still log in to Data Studio.
  • No: After the password expires, the user cannot log in to Data Studio.

Security Disclaimer

Whether the security disclaimer is enabled.

• Enable: The security disclaimer is displayed each time you try to establish an insecure connection or perform a file operation.
• Disable: You need to agree to the security implications that may arise due to insecure connection.

Environment

Session Setting

• Setting the Data Studio and file encoding. The default encoding type is UTF-8
• Whether the SQL assistant is enabled. The SQL assistant can provide suggestions or references for the content entered in the SQL terminal and stored procedure/function terminal.
• Setting the interval for automatically saving the data in the SQL terminal and stored procedure/function terminal. The interval ranges from 2 to 60. The default value is 5.
• Setting whether automatically save the result by encrypting the saved data
• Setting the display of imported table data and restrictions on imported file data

Result Management

Query Results

• Setting the number of results to be obtained: Obtain all results or a specified number of records
• Setting the width of a column
  • Content Length: setting the width of a column based on the content length of the column
  • Custom Length: setting the minimum width of a column based on the value length in network mode and the character length in text mode. The unit is pixel.
• Setting advanced copy result: copying the selected content and column title or row number.
• Whether the query result contains the result data code. If the result data code is contained, the result data code option is available when you edit and view the table, and query the results.
• Setting whether the query result contains the result data text mode. If the result data text mode is contained, the result data text mode is available when you query results (up to 30,000,000 characters are supported).
• Setting whether the query result window overwrites the result set.
  • Overwrite Resultset: After an opened result set window is closed, a new result set window will be opened.
  • Retain Current: Opens a new result set window while the already opened result set window is retained.

Edit Table Data

Setting the table data saving mode.

• Saving valid data. Invalid data is not saved and is highlighted for correction.
• No data is saved when error occurs. Invalid data is highlighted for correction.

Import/Export

Export

• Whether tablespace information is contained when DDL data is exported.
• Whether the data export function is enabled.
• Setting the export timeout period. The default value is 86400 seconds.

Sorting the result sets of view tables, editing tables, and queries in ascending, descending, or server receiving order

Alt+Click

Opening the Help menu

Alt+H

Saving the SQL script

Ctrl+S

Opening the Edit menu

Alt+E

Compiling/Executing the SQL terminal statements

Ctrl+Enter

Find and Replace

Ctrl+F

Finding the previous one

Shift+F3

Finding the next one

F3

Redoing

Ctrl+Y

Copying the information of Execution Time and Status in the Edit Table Data tab

Ctrl+Shift+K

Copying the database object from the automatic recommendation list

Alt+U

Opening the Callstack, Breakpoints, or Variables pane

Alt+V

Opening the SQL script

Ctrl+O

Skipping a single step

F8

Stepping into

F7

Stepping out

Shift+F7

Commenting out or canceling the comment line

Ctrl+/

Locating the first element in Object Browser

Alt+Page Up or Alt+Home

Locating the last element in Object Browser

Alt+Page Down or Alt+End

Locating to row

Ctrl+G

Disconnecting the connection

Ctrl+Shift+D

Formatting (SQL and PL/SQL)

Ctrl+Shift+F

Changing to uppercase

Ctrl+Shift+U

Changing to lowercase

Ctrl+Shift+L

Updating the cells or columns in the Edit Table Data, Properties, or Results pane Click the cell or column header to enable this option.

F2

Closing the PL/SQL Viewer, View Table Data, Execute Query, or Properties tab

Shift+F4

Continuing the PL/SQL debugging

F9

Cutting content

Ctrl+X

Copying the name of the object modified in Object Browser or in the terminal. You can copy the selected data from the Terminal, Result, View Table Data, or Edit Table Data tab.

Ctrl+C

Copying the data in the Result, View Table Data, or Edit Table Data tab. The data contains/does not contain the column title and row number

Ctrl+Shift+C

Copying queries in the Edit Table Data tab

Ctrl+Alt+C

Copying content of the Variables tab

Alt+K

Copying the content of the Callstack tab

Alt+J

Copying the content of the Breakpoints tab

Alt+Y

Visualized interpretation plan

Alt+Ctrl+X

Displaying online help (user manual)

F1

Template

Alt+Ctrl+Space

Switching to the first SQL Terminal tab

Alt+S

Selecting All

Ctrl+A

Opening the Setting menu

Alt+G

Refreshing the Object Browser pane

F5

Searching for objects

Ctrl+Shift+S

Opening the Debugging menu

Alt+D

Debugging a template

F10

Debugging a database object

Ctrl+D

Highlighting Object Browser

Alt+X

Opening the File menu

Alt+F

Creating a connection

Ctrl+N

Opening the Run menu

Alt+R

Switching between the SQL Terminal tabs

Ctrl+Page Up or Ctrl+Page Down

Expanding or collapsing all objects

Ctrl+M

Pasting content

Ctrl+V

Collapsing objects to browse the navigation tree

Alt+Q

Performing execution

Ctrl+E

Displaying the execution plan and expense

Ctrl+Shift+X

Stopping a running query

Shift+Esc

Commenting/Canceling the comment line or the entire segment

Ctrl+Shift+/

Opening the list of automatically recommended database objects

Ctrl+Space