Next: lists, Previous: whatprivileges, Up: workspace

### 3.4 Using editors

Editors can be in two modes. The first is read and write in which case the following key bindings are defined.

Left Arrow | Move the cursor one character to the left
Right Arrow | Move the cursor one character to the right
Up Arrow | Move the cursor one line upwards
Down Arrow | Move the cursor one line downwards
Page Up | Move the cursor one page upwards
Page Down | Move the cursor one page downwards
<BS> | Delete the character to the left of the cursor
<HOME> | Move the cursor to the beginning of the line
End | Move the cursor to the end of the line
Delete | Delete the character to the right of the cursor
SHIFT - Left Arrow | Mark text one character to the left
SHIFT - Right Arrow | Mark text one character to the right
CTRL-A | Select the entire buffer.
CTRL-B | Move the cursor one character leftwards
CTRL-C | Copy the marked text to the clipboard
CTRL-D | Delete the character to the right of the cursor
CTRL-E | Move the cursor to the end of the line
CTRL-F | Pop up the search & replace dialog
CTRL-H | Delete the character to the left of the cursor
CTRL-K | Delete to end of line
CTRL-N | Move the cursor one line downwards
CTRL-P | Move the cursor one line upwards
CTRL-V | Paste the clipboard text into line edit
CTRL-X | Cut the marked text, copy to clipboard
CTRL-Z | Undo the last operation
CTRL-Y | Redo the last operation
CTRL - Left | Arrow Move the cursor one word to the left
CTRL - Right | Arrow Move the cursor one word to the right
CTRL - Up Arrow | Move the cursor one word upwards
CTRL - Down Arrow | Move the cursor one word downwards
CTRL - Home Arrow | Move the cursor to the beginning of the text
CTRL - End Arrow | Move the cursor to the end of the text
CTRL-S | Save the editor with the current filename, if no filename is defined a dialog is displayed for the user to select the filename to use.
CTRL-O | Read a file into the editor. A dialog will pop up to select the name to open.

The second mode is read only in which only the current key binding are available.

Left Arrow | Scrolls the table to the left
Right Arrow | Scrolls the table to the right
Up Arrow Scrolls | the table one line downwards
Down Arrow | Scrolls the table one line upwards
Page Up | Scrolls the table one page downwards
Page Down | Scrolls the table one page upwards
Control-C | Copy the marked text to the clipboard
Control-S | Save the editor with the current filename, if no filename is defined a dialog is displayed for the user to select the filename to use.

Editors support drag and drop which means you can drag a selection to another editor and drop any other text source onto an editable editor to insert the dragged text at the dropped location.

Also as a shortcut pressing the right mouse button will display a context menu containing the entries from the edit menu which pertain to the editors.

#### SQL editors

Editors for SQL have another feature which is code completion. If you place the cursor after a '.' character TOra will this the available columns for the table referenced by the name before the '.' character. This will only work for defined views and tables. You can also look up tablenames using the CTRL+T key which will list all tables starting with the same word as you currently have the cursor in. When the completion list is open you can navigate it using Up, Down keys and selecting an entry using Return. You can also remove the list by pressing the Escape key. The completion values are saved in the object cache and can not be used until it is read. If you find this annoying you can disable this in the preferences.