Next: , Previous: , Up: preferences   [Contents][Index]


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
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
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.

BackgroundThe normal background color for text.
CommentAn SQL comment. Currently this only includes – comments, not rem comments.
Current backgroundThis is the background to use for the current line of execution in the PL/SQL debugger.
Error backgroundThis is the background to use for lines that have SQL errors in the in the PL/SQL debugger/editor.
KeywordThis is the color to use for the text of an SQL keyword.
NormalNormal text color.
StringColor to use for text in strings.
Unfinished stringColor 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.


Next: , Previous: , Up: preferences   [Contents][Index]