1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<html lang="en">
<head>
<title>editor - TOra</title>
<meta http-equiv="Content-Type" content="text/html">
<meta name="description" content="TOra">
<meta name="generator" content="makeinfo 4.13">
<link title="Top" rel="start" href="index.html#Top">
<link rel="up" href="preferences.html#preferences" title="preferences">
<link rel="prev" href="globalsettings.html#globalsettings" title="globalsettings">
<link rel="next" href="database.html#database" title="database">
<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage">
<!--
This manual is for TOra, version 2.1.2+.-->
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
pre.display { font-family:inherit }
pre.format { font-family:inherit }
pre.smalldisplay { font-family:inherit; font-size:smaller }
pre.smallformat { font-family:inherit; font-size:smaller }
pre.smallexample { font-size:smaller }
pre.smalllisp { font-size:smaller }
span.sc { font-variant:small-caps }
span.roman { font-family:serif; font-weight:normal; }
span.sansserif { font-family:sans-serif; font-weight:normal; }
--></style>
</head>
<body>
<div class="node">
<a name="editor"></a>
<p>
Next: <a rel="next" accesskey="n" href="database.html#database">database</a>,
Previous: <a rel="previous" accesskey="p" href="globalsettings.html#globalsettings">globalsettings</a>,
Up: <a rel="up" accesskey="u" href="preferences.html#preferences">preferences</a>
<hr>
</div>
<h4 class="subsection">3.8.2 Editor Settings</h4>
<p><a name="index-Editor-Settings-12"></a>
This page of the options contains settings for TOra editors. Editor settings are organised in two tabs: Options and Syntax.
<p><strong>Options tab</strong>
<div class="block-image"><img src="images/editor.png" alt="images/editor.png"></div>
<dl>
<dt><strong>Syntax highlighting</strong><dd> 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.
<br><dt><strong>Use maximum text width mark</strong><dd> 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 <strong>not</strong> prevent text to be writen beyond maximum text width margin. this option is purely for visual representation.
<br><dt><strong>Keyword upper</strong><dd> 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.
<br><dt><strong>Object names upper</strong><dd> 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.
<br><dt><strong>Code completion</strong><dd> Check this box to enable code completion in SQL editors.
<br><dt><strong>Editor shortcuts (TAB replacement)</strong><dd> 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".
<br><dt><strong>Sort completion rows</strong><dd> If checked the completion alternatives are sorted in alphabetical order, otherwise they are in the same order as in the source.
<br><dt><strong>Indent same as previous line</strong><dd> When inserting a new line indent it to the same level as the previous one.
<br><dt><strong>Text example</strong><dd> This is the font to use for all editors in TOra that are not syntax highlighted. Choose the <strong>Choose</strong> button immediately to the right of the label to select a new font.
<br><dt><strong>Code example</strong><dd> This is the font to use for all syntax highlighted SQL editors in TOra. Choose the <strong>Choose</strong> button immediately to the right of the label to select a new font.
<br><dt><strong>List example</strong><dd> This is the font to use for all lists in TOra. Choose the <strong>Choose</strong> button immediately to the right of the label to select a new font.
<br><dt><strong>Filename extensions</strong><dd> TODO.
<br><dt><strong>Tab stop width</strong><dd> With of tab character. This value is also used when indenting automatically generated/formated scripts.
<br><dt><strong>Use only spaces when indenting</strong><dd> TODO.
<br><dt><strong>Static checker</strong><dd> 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:
<pre class="example"> perl /usr/bin/staticChecker.pl --output=TORA --file=%1
</pre>
</dl>
<p><strong>Syntax tab</strong>
<div class="block-image"><img src="images/editor_syntax.png" alt="images/editor_syntax.png"></div>
<dl>
<dt><strong>Syntax components</strong><dd> 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.
<p>The available elements are as follows.
<p><table summary=""> <tr align="left"><td valign="top" width="30%"><strong>Background</strong> </td><td valign="top" width="70%">The normal background color for text.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Comment</strong> </td><td valign="top" width="70%">An SQL comment. Currently this only includes – comments, not rem comments.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Current background</strong> </td><td valign="top" width="70%">This is the background to use for the current line of execution in the PL/SQL debugger.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Error background</strong> </td><td valign="top" width="70%">This is the background to use for lines that have SQL errors in the in the PL/SQL debugger/editor.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Keyword</strong> </td><td valign="top" width="70%">This is the color to use for the text of an SQL keyword.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Normal</strong> </td><td valign="top" width="70%">Normal text color.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>String</strong> </td><td valign="top" width="70%">Color to use for text in strings.
<br></td></tr><tr align="left"><td valign="top" width="30%"><strong>Unfinished string</strong> </td><td valign="top" width="70%">Color to use for strings that miss their terminating ' or ".
<br></td></tr></table>
At the bottom of this dialog is a text field that displays en example of the current setting.
</dl>
</body></html>
|
