2015-04-02 13:02
ORBADA » Documentation in English » Tips and tricks » Orbada

### 4.C.1.1. Copy columns list

Plug-ins to support Oracle, MySQL, Firebird implement the functions Ctrl + F6 (view object) from the tab SQL queries. So set the cursor on the table name and select the function. In part the resulting query tab will appear with the list of columns. Look for the "copy list of columns" and select it. Now you can paste a comma separated list of columns in any place.

### 4.C.1.2. Executing a long time SQL statement

If you want to execute a long time SQL statement and also browse the database structure, use the clone connection. Cloning option is available on the SQL tab on the toolbar.

### 4.C.1.3. Sql statement queue

If you have to do a few SQL commands, you can insert it into the queue. Just in the tab SQL queries execute them one after another (Ctrl + Enter) without waiting for completion. They are inserted into the queue automatically.

### 4.C.1.4. Opening multiple connections

In the open window where selecting the schema, you can choose several connections without closing the window.
When you select schema [Enter] hold [Ctrl].

### 4.C.1.5. SELECT from table

If you want to execute a query `SELECT * FROM TAB`, you can type only the `TAB` and do [Ctrl + Enter]. In complex queries, for example to see what are the values in the column of table or see what the table has a columns, you can select only a table and do [Ctrl + Enter].

### 4.C.1.6. Colorizing the name of the connection schema

To colorize a connection schema, use HTML tags. Each name in this case must begin with <html>, and then using such <font> can colorize a part of it.
eg `<html>{user}@<font color=blue>{sid}</font>` will be displayed as "orbada@rbnora"

ORBADA » Documentation in English » Tips and tricks » Orbada
• © 2007–2015 • Andrzej Kałuża • Powered By DBPAGES • Hostet at •