# 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 riht
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
Backspace | 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
Control-A | Select the entire buffer.
Control-B | Move the cursor one character leftwards
Control-C | Copy the marked text to the clipboard
Control-D | Delete the character to the right of the cursor
Control-E | Move the cursor to the end of the line
Control-F | Pop up the search & replace dialog
Control-H | Delete the character to the left of the cursor
Control-K | Delete to end of line
Control-N | Move the cursor one line downwards
Control-P | Move the cursor one line upwards
Control-V | Paste the clipboard text into line edit
Control-X | Cut the marked text, copy to clipboard
Control-Z | Undo the last operation
Control-Y | Redo the last operation
Control - Left Arrow | Move the cursor one word to the left
Control - Right Arrow | Move the cursor one word to the right
Control - Up Arrow | Move the cursor one word upwards
Control - Down Arrow | Move the cursor one word downwards
Control - Home Arrow | Move the cursor to the beginning of the text
Control - End Arrow | Move the cursor to the end of the text
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.
Control-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.