Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

Toolbar Options

Select Database

With this option, a Query Editor to access multiple databases from multiple hosts.

It also displays the currently accessed database. You can also selectively access a database from a different host that are currently connected to the CUBRID Manager. In the figures below, yellow highlighted sections mean the followings: the left one is displayed when it is accessed by DBA; the right one is displayed when no database is selected. The former makes you to check out which account is currently used; the latter allows you to select a database to connect when no database connection is made.

manager_queryeditor_toolbar_seldb.png manager_queryeditor_toolbar_seldb2.png

If you select a different database without stopping transactions in the currently accessed database, you are prompted whether to commit or rollback transactions in progress as below.

manager_queryeditor_toolbar_seldbconfirm.png

Toolbar Options

The edit function of the Query Editor is synchronized with [Edit] on the menu. The following table shows the options available on the Query Editor's toolbar: Major options are provided with a shortcut key.

manager_queryeditor_toolbar.png

Option

Icon

Shortcut Key

Description

Open

icon_open.png

 

Opens a text-based SQL and displays it in the query edit pane.

Save

icon_save.png

 

Saves the contents of the query edit pane.

Save As

icon_saveas.png

 

Saves the contents of the query edit pane in a different name.

Run

icon_run.png

F5

Executes all the queries in the query edit pane. Alternatively, executes queries selected as a block. This icon is deactivated when the execution is unavailable (icon_runinactive.png).

Commit

icon_commit.png

 

Keeps deactivated in autocommit mode (icon_commitinactive.png); while in non-autocommit mode, allows you to commit (icon_commit.png) explicitly when a transaction occurs.

Rollback

icon_rollback.png

 

Keeps deactivated in autocommit mode (icon_rollbackinactive.png); while in non-autocommit mode, allows you to rollback (icon_rollback.png) explicitly when a transaction occurs.

auto commit

icon_autocommitoff.png

 

Automatically commits queries executed in the query edit pane. You can toggle the icon. When auto commit is on, the icon is displayed as icon_autocommiton.jpg, and when it is off, the icon is displayed as icon_autocommitoff.png.
Note that the setting is only applied to the corresponding Query Editor; that is the default value of the option is not changed.

Display query plan

icon_queryplan.png

F6

Displays the execution plan of the selected query. For more information, see Query Execution Plan.

Undo

icon_undo.png

Ctrl+Z

Cancels the most recent edit action.

Redo

icon_redo.png

Ctrl+Y

Re-executes the most recent edit action that is canceled by Undo.

Find/Replace

icon_search.png

Ctrl+F

Provides search and replace function that can be used in the query edit pane.

Find next

icon_searchnext.png

F3

Provides further search for items that are already searched once.

Convert to comment

icon_addcomment.png

Ctrl+/

Adds the comments to the selection area or to the line where the cursor is located in the query edit pane. Comment strings are inserted with a double dash (--).

Delete comment string

icon_delcomment.png

Ctrl+/

Deletes the comments from the selection area or from the line where the cursor is located in the query edit pane.

Insert tab

icon_indent.png

Tab

Indents the selection area in the query edit pane.

Delete tab

icon_unindent.png

Shift+Tab

Un-indents the selection area in the query edit pane.

Format SQL

icon_format.png

Ctrl+Shift+F

Formats the selected SQL strings in the query edit pane.

Get OID info

icon_update.png

 

A toggle button available on the toolbar in the query edit pane for [Get OID info], which can be found in the Query Editor options. That is, by selecting this button on the toolbar when [Get OID info], which can be found in the Query Editor options, is OFF, you can directly modify/delete data in the query results pane for subsequent queries. In this button is selected on the toolbar, however, this only applies to the corresponding Query Editor. The values of the Query Editor options for the corresponding database won't be changed.

Set defined SQL parameter

icon_parameter.png

 

To specify a parameter whenever the statement is executed, write Prepared Statement, select the written statement, and click the icon.

Quick Help

icon_help.png

  Show the help about the selected text in the editor.
Show/Hide Query Result icon_result.png   Show or hide the query result pane.