Global Navigation Bar (GNB)
The GNB is configured with a total of 8 areas.
File
Provides basic file management functions such as working with files, managing connections to database servers, viewing session information, saving, and exiting.
New Editor (N)
Opens a new editing window.(SQL Editor, PSM Editor)
-
└ SQL Editor (S)
Opens the SQL Editor window.
Alt + S
└ PSM Editor (P)
Opens the PSM Editor window.
Alt + P
Open File (O)
Opens an existing file in the Editor area to write or view SQL or PSM.
Ctrl + O
Recent Editor
Displays a list of recently worked editor files.
-
└ Recent action 1
Displays the name of the most recently opened file by the user. (ex: recent_file.sql)
-
└ Recent action 2
The second most recent file opened
-
└ Clear History
Removes all history from the Recent Editor list.
-
New Connection
Creates a new database connection. The New Connection Settings window opens.
Ctrl + N
Invalid / Reconnect Connection
Creates a new connection or reconnect an existing connection if the current connection is invalid.
-
End Connection (D)
Ends the currently focused database connection.
Ctrl + E
End All Connection (I)
Ends all database connections.
Ctrl + Shift + E
Session Info (E)
Views information about the current connection session.
-
Change Password
Changes the user password.
-
Save (S)
Saves the file currently being edited.
Ctrl + S
Save As
Saves the file currently edited with a different name.
-
Save All (L)
Saves all open editing files.
Ctrl + Shift + S
Switch Default Folder
Changes the default working folder.
-
Exit (X)
Exits Tibero Studio.
Alt + F4
Edit
Supports editor-related operations such as text editing, formatting, case conversion, and autocomplete.
Undo (U)
Undoes the previous action.
Ctrl + Z
Redo (R)
Redoes the undone action.
Ctrl + Y
Cut (T)
Cuts the selected text and copy it to the clipboard.
Ctrl + X
Copy (C)
Copies the selected text to the clipboard.
Ctrl + C
Paste (V)
Pastes the copied or cut text.
Ctrl + V
Delete (D)
Deletes the character at the cursor or delete the text within the selected area.
Delete
Delete All (E)
Deletes all text in the current editor.
Ctrl + Shift + Delete
Select All (A)
Selects all text in the current editor.
Ctrl + A
Find & Replace (F)
Opens the Find & Replace modal to search for or replace specific text in the current editor.
Ctrl + F
Auto Complete
Executes autocomplete when writing code.
Ctrl + Space
Format
Formatting
Makes a single irregular, hard-to-read SQL look good, making it more readable.
Ctrl + Shift + F
Format All
Makes all irregular, hard-to-read SQL look good, making it more readable.
Alt + Shift + F
Trim Spaces
Automatically removes unnecessary spaces at the end of lines of code or text.
Ctrl + Shift + Backspace
Word Wrap
Automatically wraps long lines of text to fit the editor window size to see the entire content without horizontal scrolling.
Ctrl + Alt + Shift + W
Single Line Comments
Comments a single line of text in SQL using the '--' symbol.
Ctrl + /
Multi Line Comments
Comments multiple lines of text at once using the '/* */' symbol in SQL.
Ctrl + Shift +/
Indent
IndentIndents the selected line.
Tab
Unindent
Removes indentation from the selected line.
Shift + Tab
Convert
Lower Case
Changes all selected text to lowercase.
Ctrl + U
Upper Case
Changes all selected text to uppercase.
Ctrl + Shift + U
Capitalize
Changes the first letter of each word in the selected text to uppercase, and the rest of the text to lowercase.
Ctrl + K
Sentensize
Converts the selected text to sentence format, capitalizing the first letter of each sentence and lowercasing the rest of the text.
Ctrl + Shift + K
Invert Case
Inverts the case of the selected text.
Ctrl + I
Run
provides SQL execution, execution plan check, transaction control (Commit, Rollback), PSM compilation and execution, etc.
Run SQL
Runs a single SQL where the cursor is currently located. If running it after blocking a specific area of the SQL written, it will run the SQL in the blocked area.
Ctrl + Enter
Run All From Cursor
Runs all SQL statements from the current cursor position to the end.
Ctrl + [
Run Step
Runs one by one from the current cursor and moves to the next SQL statement.
Ctrl + ]
Run SQL Script
Runs all SQL statements in the tab where the cursor is currently located.
F5
Run SQL NewTab
Runs a SQL script in a new tab.
F6
Run Subquery Block
Runs a subquery where the cursor is currently located.
Alt + F5
Execution Plan
Shows the execution plan for the current SQL statement.
F7
SQL Trace
Displays statistical information about the SQL statements run.
F9
Commit
Permanently saves the data changes made in the current Editor session to the database.
Ctrl + Shift + C
Rollback
Permanently cancels the data changes made in the current Editor session.
Ctrl + Shift + R
Compile
Compiles the created PSM.
Ctrl + Shift + P
Debug
Debugs the created PSM.
Ctrl + Shift + D
Run PSM
Runs the created PSM.
Ctrl + Shift + N
Append Query Result
Leaves the result of the previous execution and adds the result of the execution.
Ctrl + .
View
Provides screen layout-related functions such as splitting the work screen, moving and managing tabs, and viewing DBMS output and SQL history.
Maximize Editor
EditorMaximizes the Editor area to enlarge the work screen.
Alt + Arrow Down
Maximize Result
ResultMaximizes the Result area to show a wider view of the run result.
Alt + Arrow Up
Schema Tree Browser
BrowserReopens the Schema Object Tree Browser if it is closed.
Alt + T
Split Vertical
Splits the Editor area vertically.
-
Split Horizontal
Splits the Editor area horizontally.
-
Collapse Tab Group
Merges a group of split tabs and displays them as a single tab.
-
DBMS Output
Opens the DBMS Output window for debugging and viewing output messages.
-
SQL History
Shows the history of SQL statements that have been run.
F8
Task List
Opens the Task List window for managing task lists.
-
Template
Opens the Template window to save and manage frequently used SQL statements or PSM code as predefined templates.
F3
Recompile Invalid Object
Opens a modal window to recompile invalid objects.
-
Move
Moves or copies the tab currently working in.
-
└ Next Tab
Moves to the next tab.
F4
└ Previous Tab
Moves to the previous tab.
Shift + F4
└ Copy To Next Tab
Copies the contents of the current editor tab and creates another identical editor tab.
-
Close Tab (C)
Closes the tab currently working in.
Ctrl + W
Close All Tab
Closes all open tabs.
Ctrl + Shift + W
Close Other Tab
Closes all other tabs except the current tab.
-
Window
customizes the settings of Tibero Studio on User Preferences.
Preference
Customizes themes, editor settings, hotkeys, and more on the preferences menu.
Ctrl + Alt + P
Help
Provides program information and help.
About
Displays information about Tibero Studio. Finds detailed information about the application, such as version, release notes, copyright, etc.
-
Help
Opens help for using Tibero Studio.
-
Window Control Buttons
This area contains the buttons used to control the windows in Tibero Studio, located in the upper right corner. Each button performs the following features.
(Minimize)
Minimizes the current window and hides it in the task bar.
(Maximize)
Enlarges the window to full screen size or restores it to its original size.
(Close)
Closes the Tibero Studio window.
Last updated