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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
|
<HTML><HEAD><TITLE>Database Browser</TITLE></HEAD><BODY>
<H1>Database Browser</H1>
This tool provides you a simple browser for exploring database schema objects. Initially it can
be said that the browser also provides a browser like functionality for the
<A HREF=template.html>template help</A> which is covered separately. This browser will provide
you with more information and you will also in future versions of TOra be able to interact with
schema objects (Dropping or create tables etc.), this is not possible in the template help version.
The <A HREF=template.html>template help</A> on the other hand is tree based and some people
consider it easier and faster to work with.<P>
<IMG SRC=images/browser.png><P>
<H2>Using the browser</H2>
The database browser has a very simple interface with a toolbar which contain the following
functions. All of these are also available in the <B>Browser</B> menu item except for the
schema selection and change object.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Refresh
</B></TD><TD>
Refresh the displayed data from the database. Also available on the
<B>F5</B> key.
</TD></TR>
<TR><TD VALIGN=top><B>
Define filter</B></TD><TD>
Displays the <A HREF=browser.html#filter>define filter dialog</A>. This is used to specify which
objects to show in the browser. The default filter is to show everything. Also available on the
<B>CTRL+SHIFT+G</B> key.</TD></TR>
<TR><TD VALIGN=top><B>
Clear filter</B></TD><TD>
Remove the current filter and revert to the default of showing everything. Also available on the
<B>CTRL+SHIFT+H</B> key.</TD></TR>
<TR><TD VALIGN=top><B>
Schema</B></TD><TD>
The last item on the toolbar is a combo box where you can select the schema to display
objects for. It defaults the schema you are currently logged in as. Only schemas that are
visible to the current user is selectable in the lost (Really, TOra does not contain the
secret DBA password that will always let you access everything regardless of your privileges).
</TD></TR>
<TR><TD VALIGN=top><B>
Change connection</B></TD>
<TD VALIGN=top>
Change the connection this tool window should operate on.</TD></TR>
</TABLE><P>
The rest of the interface consists of two tabbed windows, one within the other. The first one
you can use to select the object type you want to inspect. When you have selected a type you
can see the visible objects of the specified type available in the selected schema. The second
tab indicate what kind of information you want to explore about the selected object and depends
on the object type (For more information about available information see
<A HREF=browser.html#types>this</A>). When you select an object name in the left list you
can inspect information about it to the right.<P>
You can move the keyboard focus to the schema selection using <B>ALT+S</B> and to the current
object list using <B>ALT+N</B>.
<A NAME=types><H2>Available information</H2>
This is the available information for the different object types.<P>
<TABLE>
<TR><TD><I>Object type</I></TD><TD><I>Name</I></TD><TD><I>Description</I></TD></TR>
<TR><TD VALIGN=top><B>
Tables</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Columns</B></TD><TD VALIGN=top>
A description of the columns in the table. For more information about this information also see
<A HREF=common.html#describe>object description</A>.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Indexes</B></TD><TD VALIGN=top>
A list with the indexes that have been created for this table.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Constraints</B></TD><TD VALIGN=top>
Lists the constraints for this table.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
References</B></TD><TD VALIGN=top>
Displays the foreign key constraints that references this table and the other objects that have
dependencies on this table.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this table.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Triggers</B></TD><TD VALIGN=top>
Lists the triggers that exist for this table.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Data</B></TD><TD VALIGN=top>
Displays the data in the table. This is the only part of the database browser that let you modify any data. For
more information about how to use the content editor see <A HREF=browser.html#content>this</A>.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Information</B></TD><TD VALIGN=top>
Contains information about the table available in the SGA including
analyzed statistics etc.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
Views</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Columns</B></TD><TD VALIGN=top>
A description of the columns in the view. For more information about this information also see
<A HREF=common.html#describe>object description</A>.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
SQL</B></TD><TD VALIGN=top>
The SQL that defines the view.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Data</B></TD><TD VALIGN=top>
Displays the data in the view. This is the only part of the database browser that let you modify any data. For
more information about how to use the content editor see <A HREF=browser.html#content>this</A>. You can not
modify some views depending on how they are defined. See the Oracle reference for more information about editing
views.
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this view.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Dependencies</B></TD><TD VALIGN=top>
The objects that depend on this view.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
Indexes</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Columns</B></TD><TD VALIGN=top>
The columns that the index operate on.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Info</B></TD><TD VALIGN=top>
Information in the SGA about an index. For instance analyzed statistics available for this index.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
Sequences</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Info</B></TD><TD VALIGN=top>
Information about the sequence.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this object.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
Synonyms</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Info</B></TD><TD VALIGN=top>
Information about the synonyms</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this object.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
PL/SQL</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Declaration</B></TD><TD VALIGN=top>
The declaration of a package or type.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Body</B></TD><TD VALIGN=top>
The implementation of a package, body, procedure or function.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this object.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Dependencies</B></TD><TD VALIGN=top>
Dependencies this object has.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
<TR><TD VALIGN=top><B>
Triggers</B></TD><TD></TD><TD VALIGN=top>
</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Info</B></TD><TD VALIGN=top>
Information about the trigger.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Code</B></TD><TD VALIGN=top>
The code that implement the trigger.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Columns</B></TD><TD VALIGN=top>
The columns this trigger operates on.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Grants</B></TD><TD VALIGN=top>
The grants that have been made on this object.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Dependencies</B></TD><TD VALIGN=top>
Dependencies of this object.</TD></TR>
<TR><TD></TD><TD VALIGN=top><B>
Script</B></TD><TD VALIGN=top>
This tab displays an SQL script to recreate the database object.</TD></TR>
</TABLE><P>
<A NAME=content><H2>Content editor</H2>
The content let you edit the contents of a table or view. There are a few things to note about this.<P>
First of all the content editor is designed to behave nicely to the database which means that it
will only save the data when it thinks you are finished editing a row. This happens when you the current row
change or you commit the database. When there is unsaved data you can see it in the status bar that there
exists unsaved data. Also observe that the content editor will respect the auto commit setting in the
<A HREF=database.html>database settings</A>.<P>
The content editor has it's own toolbar with the following buttons.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Define filter</B></TD><TD>
Displays the <A HREF=browser.html#contentfilter>define filter dialog</A>. This is used to specify which
objects to show in the browser. The default filter is to show everything.</TD></TR>
<TR><TD VALIGN=top><B>
Clear filter</B></TD><TD>
Remove the current filter and revert to the default of showing everything.</TD></TR>
<TR><TD VALIGN=top><B>
Add new record
</B></TD><TD>
Add a new record to the current table.
</TD></TR>
<TR><TD VALIGN=top><B>
Save changes
</B></TD><TD>
Save the changes made to the current row to the database. Observe that this will not commit the changes.
</TD></TR>
<TR><TD VALIGN=top><B>
Discard changes
</B></TD><TD>
Discard the changes made to the current row to the database. Observe that this will not rollback the database connection.
</TD></TR>
<TR><TD VALIGN=top><B>
Delete current record
</B></TD><TD>
Delete the current record from the database.
</TD></TR>
<TR><TD VALIGN=top><B>
Go to first row
</B></TD><TD>
Go to the first record in the editor.
</TD></TR>
<TR><TD VALIGN=top><B>
Go to previous row
</B></TD><TD>
Go to the previous record in the editor.
</TD></TR>
<TR><TD VALIGN=top><B>
Go to next row
</B></TD><TD>
Go to the next record in the editor.
</TD></TR>
<TR><TD VALIGN=top><B>
Go to last row
</B></TD><TD>
Go to the last record in the editor. Observe that this will read in all available records in the table into memory.
</TD></TR>
</TABLE><P>
<A NAME=contentfilter>
The content editor can define a fileter to specify which part of a table to edit. This dialog looks like this.<P>
<IMG SRC=images/contentfilter.png><P>
In the <B>selection criteria</B> part you can add whatever you want to go after a <B>where</B> in a select statement.
In the <B>sort order</B> you can list the columns you want to sort on. The sort order only affect the order the records
are read from the database, after they are read you can still sort on any column by clicking it. To the right is a
list of available columns in the table.<P>
Finally at the bottom is a checkbox called <B>use for all tables</B>. If this box is checked the index is used for
all tables, if not checked you can define specific filters for each tables and the content editor will remember the
different filters as you jump between tables. The reason for this is that it's quite common that not all tables have
all the columns you want to filter on for a table, in this case you will get an error trying to access the table
with a faulty filter setting.<P>
<A NAME=filter><H2>Defining a filter</H2>
Filtering is based on the object name and can be specified in a variety of ways. This
is the dialog used to specify the filter.<P>
<IMG SRC=images/browserfilter.png><P>
The most important part of this dialog is the editor which let you specify the string
to apply the criteria to. This is not available for <B>No filter</B> setting.
The different available types and options are.<P>
<TABLE>
<TR><TD VALIGN=top><B>
No filter</B></TD><TD>
No filter specified, display all objects.</TD></TR>
<TR><TD VALIGN=top><B>
Start with</B></TD><TD>
Only include objects which name starts with the specified string.</TD></TR>
<TR><TD VALIGN=top><B>
End with</B></TD><TD>
Only include objects which name ends with the specified string.</TD></TR>
<TR><TD VALIGN=top><B>
Contains</B></TD><TD>
Only include objects which name contain the specified string.</TD></TR>
<TR><TD VALIGN=top><B>
RegExp</B></TD><TD>
Only include objects which name matches the regular expression specified in the editor. The dialect of RegExp:s
is the ones in the version of Qt that TOra is compiled against.
For more information on regular expressions check out
<A HREF=http://doc.trolltech.com/qregexp.html>http://doc.trolltech.com/qregexp.html</A>, if you are using Qt 3.0
or later you have a more advanced form of regular expressions.</TD></TR>
<TR><TD VALIGN=top><B>
Ignore case</B></TD><TD>
Ignore the case when matches. Since object names are pretty much always uppercase it is probably safest to leave this on.</TD></TR>
<TR><TD VALIGN=top><B>
Invert selection</B></TD><TD>
If set, include all the objects that does not meet the specified criteria instead of the ones which does.</TD></TR>
</TABLE><P>
Some objects you can also search on what tablespace they are located on. This can be specified by the lower
part of the dialog.<P>
<TABLE>
<TR><TD VALIGN=top><B>
Include all</B></TD><TD>
Include all regardless of tablespace.</TD></TR>
<TR><TD VALIGN=top><B>
Include</B></TD><TD>
Include the objects located on the selected tablespaces in the list below.</TD></TR>
<TR><TD VALIGN=top><B>
Exclude</B></TD><TD>
Include the objects not located on the selected tablespaces in the list below.</TD></TR>
</TABLE>
</BODY>
</HTML>
|