Next: , Previous: globalsettings, Up: preferences


3.8.2 Editor Settings

This page of the options contains settings for TOra editors. Editor settings are organised in two tabs: Options and Syntax.

Options tab

images/editor.png
Syntax highlighting
Use this to control whether you want syntax highlighting or not. Observe that without syntax highlighting you will not see the indications for errors and current lines in the PL/SQL editor.
Use maximum text width mark
Check this option and specify maximum length of text. A vertical line indicating this margin will be displayed in text editor. Note that this option will not prevent text to be writen beyond maximum text width margin. this option is purely for visual representation.
Keyword upper
Check this box to convert all keywords to uppercase before displaying them. The text itself is not changed so resetting this not changed and the text sent to the database still contain lowercase letters. This setting is disabled if you do not have a monospaced font selected.
Object names upper
Extract all names of objects (tables, views, columns etc.) from database as uppercase (default). For example this setting will be used when generating object creation scripts.
Code completion
Check this box to enable code completion in SQL editors.
Editor shortcuts (TAB replacement)
By checking this option and pressing a button "Edit..." you can add/modify/delete editor shortcuts. Editor shortcut is a short word which can be replaced to a long phrase by pressing TAB button. For example you can set that a short word "selsysd" be replaced with "select sysdate from dual".
Sort completion rows
If checked the completion alternatives are sorted in alphabetical order, otherwise they are in the same order as in the source.
Indent same as previous line
When inserting a new line indent it to the same level as the previous one.
Text example
This is the font to use for all editors in TOra that are not syntax highlighted. Choose the Choose button immediately to the right of the label to select a new font.
Code example
This is the font to use for all syntax highlighted SQL editors in TOra. Choose the Choose button immediately to the right of the label to select a new font.
List example
This is the font to use for all lists in TOra. Choose the Choose button immediately to the right of the label to select a new font.
Filename extensions
TODO.
Tab stop width
With of tab character. This value is also used when indenting automatically generated/formated scripts.
Use only spaces when indenting
TODO.
Static checker
Specifies static checker to be used. This configuration option should contain %1 which will be replaced with a filename (with full path) containing code to be checked. For example:
          perl /usr/bin/staticChecker.pl --output=TORA --file=%1

Syntax tab

images/editor_syntax.png
Syntax components
This list contains different parts of the SQL syntax. You can change the color used for the element by selecting the item in this list and then pressing the Pick button to select a color. The current color of the currently selected item in the list is displayed just to the left of the Pick button.

The available elements are as follows.

Background The normal background color for text.
Comment An SQL comment. Currently this only includes – comments, not rem comments.
Current background This is the background to use for the current line of execution in the PL/SQL debugger.
Error background This is the background to use for lines that have SQL errors in the in the PL/SQL debugger/editor.
Keyword This is the color to use for the text of an SQL keyword.
Normal Normal text color.
String Color to use for text in strings.
Unfinished string Color to use for strings that miss their terminating ' or ".
At the bottom of this dialog is a text field that displays en example of the current setting.