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.

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.

Toolbar Options

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

Option

Icon

Shortcut Key

Description

Open

 

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

Save

 

Stores the contents of the query edit pane.

Save As

 

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

Run

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 ().

Commit

 

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

Rollback

 

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

auto commit

 

Automatically commits queries executed in the query edit pane. You can toggle the icon. When auto commit is on, the icon is displayed as , and when it is off, the icon is displayed as .
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

F6

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

Undo

Ctrl+Z

Cancels the most recent edit action.

Redo

Ctrl+Y

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

Find/Replace

Ctrl+F

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

Find next

F3

Provides further search for items that are already searched once.

Convert to comment

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

Ctrl+/

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

Insert tab

Tab

Indents the selection area in the query edit pane.

Delete tab

Shift+Tab

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

Format SQL

Ctrl+Shift+F

Formats the selected SQL strings in the query edit pane.

Get OID info

 

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

 

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

Quick Help

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