General¶
This section provides details on how to customize shortcut keys.
Setting the Shortcut Keys¶
You can customize the Data Studio shortcut keys as required.
Follow the steps below to set or modify the shortcut keys:
Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
Choose General > Shortcut Mapper.
The Shortcut Mapper pane is displayed.
Select the required shortcut key and click Modify.
Enter the required shortcut key in the Binding text box.
For example, to change the shortcut key for Step Into from F7 to F6, enter F6 in the Binding text box.
Click OK. The Restart Data Studio dialog box is displayed.
Note
Multiple shortcut keys can be modified before restarting Data Studio.
Click Yes to restart Data Studio. If any export, import or execution operations are in progress, then the Restart Confirmation dialog box is displayed.
Click OK to close running jobs and restart or click Cancel to abort restart operation.
Follow the steps below to remove the shortcut keys:
Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
Choose General > Shortcut Mapper.
The Shortcut Mapper pane is displayed.
Select the required shortcut key and click Unbind Key.
Click Ok. The Restart Data Studio window is displayed.
Note
Multiple shortcut keys can be removed before restarting Data Studio.
Click Yes to restart Data Studio. If any export, import or execution operations are in progress, then the Process is running dialog box is displayed.
Click OK to wait for operations to complete or click Force Restart to discard operations.
Follow the steps below to restore the default shortcut keys:
Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
Choose General > Shortcut Mapper.
The Shortcut Mapper pane is displayed.
Click Restore Defaults. For more information on default shortcut keys, refer to Data Studio Right-Click Menus.
Click Ok.
The Restart Data Studio window is displayed.
Click Yes to restart Data Studio. If any export, import or execution operations are in progress, the Process is running dialog box displays.
Click OK to wait for operations to complete or click Force Restart to discard operations.
Shortcut Keys¶
Data Studio supports keyboard short cut keys similar to other windows based application. The following table lists some of the shortcut keys for effective usage of the functionalities provided by Data Studio. For details about how to customize shortcut keys, see Setting the Shortcut Keys.
Function | Shortcut Key |
---|---|
Sorts the result sets of visual charts, edit tables, and queries in ascending, descending, or server receiving order | Alt+Click |
Open the Help menu | Alt+H |
Save the SQL script | Ctrl+S |
Edit menu | Alt+E |
Compile/Execute SQL terminal statements | Ctrl+Enter |
Search and Replace | Ctrl+F |
Search for the previous one | Shift+F3 |
Search for the next one | F3 |
Redoing | Ctrl+Y |
On the Edit Table Data tab page, copy Execution Time and Status | Ctrl+Shift+K |
Copy the database object from the automatic recommendation list | Alt+U |
Open the Call Stack, the Breakpoints pane, and the Variables pane | Alt+V |
Open the SQL script | Ctrl+O |
Step Skip | F8 |
Step into | F7 |
Single step exit | Shift+F7 |
Comment out or cancel the comment line | Ctrl+/ |
Locate the first element in the Object Browser | Alt+Page Up or Alt+Home |
Locate the last element in the Object Browser | Alt+Page Down or Alt+End |
Locate to row | Ctrl+G |
Disconnect the connection | Ctrl+Shift+D |
Formatting (SQL and PL/SQL) | Ctrl+Shift+F |
Change the value to uppercase | Ctrl+Shift+U |
Change the value to lowercase | Ctrl+Shift+L |
Updates the cells or columns in the Edit Table Data, Properties, and Results windows. Click the cell or column header to enable this option | F2 |
Close the PL/SQL Viewer tab page, Table Data View tab page, Execute Query tab page, or Properties tab page | Shift+F4 |
Continue the PL/SQL debugging | F9 |
Shearing | Ctrl+X |
Copy Object Browser or the name of the object modified in the terminal. Copy the selected data from the Terminal, Result, Table Data, or Edit Table Data tab page. | Ctrl+C |
Copy the data on the Result, Table Data, or Edit Table Data tab page. The data contains/does not contain the column title and row number | Ctrl+Shift+C |
Copy the query result on the Edit Table Data tab page | Ctrl+Alt+C |
Copy the content on the Variable tab page | Alt+K |
Copy the content on the Call Stack tab page | Alt+J |
Copy the content on the Breakpoint tab page | Alt+Y |
Visualized interpretation plan | Alt+Ctrl+X |
Online help (displaying the user manual) | F1 |
Template | Alt+Ctrl+Space |
Switch to the first SQL Terminal tab page | Alt+S |
Select All | Ctrl+A |
Setting menu | Alt+G |
Refresh (in the Object Browser area) | F5 |
Search Object | Ctrl+Shift+S |
Debugging menu | Alt+D |
Debugging template | F10 |
Debugging the Database Object | Ctrl+D |
Highlight Object Browser | Alt+X |
File menu | Alt+F |
Creating a connection | Ctrl+N |
Running menu | Alt+R |
Switch between the SQL Terminal tab page | Ctrl+Page Up or Ctrl+Page Down |
Expand/Collapse All Objects | Ctrl+M |
Pastes | Ctrl+V |
Collapsible object browsing navigation tree | Alt+Q |
Execute | Ctrl+E |
Execution plan and expense | Ctrl+Shift+X |
Stop the query in the running state | Shift+Esc |
Comment/Cancel the comment line or the entire segment | Ctrl+Shift+/ |
List of automatically recommended database objects | Ctrl+Space |