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"