Customizing Data Studio

Updated on 2025-01-09 GMT+08:00

View PDF

In the navigation pane on the left, choose Settings > Preferences. You can customize Data Studio based on preferences.

**Table 1** Functions of preferences
Preferences	Options	Description
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. For details about how to use the template, see Using Templates.
	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	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. 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.
Result Management	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.

**Table 2** Default shortcut keys of Data Studio
Function	Shortcut Key
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