Shortcuts

Shortcuts Settings

Search Field

Filters the options shown through the feature name. Partial search is possible and case insensitive. When entering a value in the field, only features that contain the word searched for will be filtered and highlighted if there is a match.

Shortcuts

Views features and their shortcuts by category. Clicks the category name to collapse or expand it.

The user can enter edit mode by clicking the shortcut area of a feature that can be changed (unchangeable features are grayed out) then type the desired shortcut and press Enter to apply it.

In case of duplication with other functions, the user can check the function to which the key is mapped through the error message in the lower left corner. (However, shortcuts in SQL Editor and PSM Editor can be duplicated with each other).

Default shortcut list

The default shortcuts for each category are as follows

PSM Editor

Feature
Shortcut
Description
Change

Subprogram

Ctrl+G

Shows or hides Subprogram Tree.

PSM Debug

Ctrl+Shift+D

Debugs PSM statement.

PSM Run

Ctrl+Shift+N

Executes PSM statement.

PSM Compile

Ctrl+Shift+P

Executes PSM Compile.

Terminate PSM Debug

Ctrl+Shift+T

Terminates debugging.

Breakpopint

F5

Sets the Breakpoint in current Line.

Step Any Return

F6

Moves the debug line to the next line in the procedure

Step Into

F7

Moves the debug line to the next line (if it is a procedure call, procedure, move the debug line into the procedure)

Resume

F8

Moves the debug line to the next set breakpoint.

Step Over

F9

Moves the debug line to the next linetrue.

SQL Editor

Feature
Shortcut
Description
Change

Run Subquery Block

Alt+F5

Executes the subquery where the current cursor is located.

Run All From Cursor

Ctrl+[

Executes multiple SQL from the SQL statement where the current cursor is located to the last SQL statement.

Run Step

Ctrl+]

After running a single SQL where the current cursor is located, Moves the cursor to the next SQL statement.

Uncommitted Transaction List

Ctrl+Alt +Shift+U

Opens Uncommitted List window.

Run SQL

Ctrl+Enter

Executes a single SQL at the current cursor. If it is executed after blocking a certain area of the SQL wrote, it will run the SQL in the blocked area.

Run SQL Script

F5

Executes all multiple SQL written in the Editor.

Run SQL NewTab

F6

Executes a single SQL (same as Run SQL), and creates a new result window.

Current SQL Plan

F7

Views the SQL Plan.

SQL History

F8

Opens the SQL History Tab.

Show SQL Trace

F9

View the SQL Trace information.

Common

Feature
Shortcut
Description
Change

Maximize Editor

Alt +Arrowdown

Maximizes the Editor window.

Close

Alt+F4

Closes the application.

Line Number Display

Alt+L

Toggles the line number display option.

Open a new PSM Editor

Alt+P

Creates the new PSM Editor window.

Split Pane Evenly

Alt +Arrowright

Open a new SQL Editor

Alt+S

Creates the new SQL Editor window.

Schema Tree Browser

Alt+T

Opens the Schema Tree window.

Maximize Result

Alt+Arrowup

Maximizes the Result window.

Append Query Result Tab

Ctrl+.

Creates the new Result tab when generating results in SQL Editor.The default is False.

Show Shortcut List

Ctrl+Alt+L

Opens the Preference - Shortcut window.

Preferences

Ctrl+Alt+P

Opens the Preference window.

Open Recent Editor

Ctrl+Alt+T

Opens the Open Recent Editor menu of GNB.

Toggle Result Tab

Ctrl+H

Collapses or expands the Result Tab.

Close All Tab

Ctrl+Shift+W

Closes all tabs in the focused group.

Close Tab

Ctrl+W

Closes tabs in the focused group.

Template

F3

Opens the Template area.

Go to Next Tab

F4

Moves to the next tab in the focused group.

Go to Prev Tab

Shift+F4

Moves to the previous tab in the focused group.

File

Feature
Shortcut
Description
Change

End Connection

Ctrl+E

Disconnects the selected connection.

New Connection

Ctrl+N

Opens the Create Connection window.

Open File

Ctrl+O

Loads a script saved in a file.

Save

Ctrl+S

Saves the contents of the script to a file.

Commit

Ctrl+Shift+C

Executes Commit

End All Connection

Ctrl+Shift+E

Disconnects all connected connections.

Rollback

Ctrl+Shift+R

Executes Rollback.

Save All

Ctrl+Shift+S

Saves the contents of all currently open editor.

Edit

Feature
Shortcut
Description
Change

Format All

Alt+Shift+F

Makes all irregular and hard-to-read SQL look nice, making it more readable.

Multi Line Comment

Ctrl+Shift+/

Comments the selected area with a block comment (/* */)

Redo

Ctrl+Y 또는Ctrl+Shift+Z

Reruns a canceled execution.

Single Line Comment

Ctrl+/

Comments the selected line with a single line comment (--).

Clear DBMS Output

Ctrl+,

Deletes the DBMS Output contents of the selected tabs.

Select All

Ctrl+A

Selects all contents.

Copy

Ctrl+C

Copies the selected area.

Find/Replace

Ctrl+F

Calls the Find/Replace window.

Invert Case

Ctrl+I

Reverses the case of the selected text, converts uppercase to lowercase and lowercase to uppercase.

Capitalize

Ctrl+K

Capitalizes the first letter of each word in the selected text and converts the rest to lowercase.

Uncomment

Ctrl+Shift+-

Deletes comments. If the line is uncommented, it will be commented out.

Word Wrap

Ctrl+Shift +Alt+W

Automatically wraps long lines of text to fit the editor window size.

Trim Spaces

Ctrl+Shift +Backspace

Automatically removes unnecessary spaces at both ends of lines of code or text. unnecessary spaces at the end of lines of code or text.

Delete All

Ctrl+Shift +Delete

Deletes all current scripts.

Formatting

Ctrl+Shift+F

Makes irregular, hard-to-read single SQL more readable by making it readable.

Sentensize

Ctrl+Shift+K

Capitalizes the first letter of a sentence and converts the rest to lowercase. the rest in lowercase.

Upper Case

Ctrl+Shift+U

Converts all letters in the selected text to uppercase.

Auto Complete WIndow

Ctrl+Space

Calls the AutoComplete window.

Lower Case

Ctrl+U

Converts all letters in the selected text to lowercase to lower case.

Paste

Ctrl+V

Pastes copied contents.

Cut

Ctrl+X

Cuts the selected area.

Undo

Ctrl+Z

Undoes the operation.

Delete

Ctrl+Delete

Deletes the selected area.

Indent

Tab

Executes indents.

UnIndent

Shift+Tab

Executes outdents.

Last updated