Plus - Setting Options
ISDS System Usability Director is
responsible for ensuring that this document is necessary, reflects actual
practice, and supports University policy.
Enter connection details > Go > Cancel > Blank Workbook > Tools
1. Select the Run option that you want.
Run a query automatically
means that as soon as you open the workbook the query runs and you get the
run query (leave the sheet empty). If you want the results windows to appear,
you need to select the
The default option is set at
‘Ask for confirmation’ resulting in the appearance of this familiar decision
box when you open a workbook.
2. Enter  in the number of workbooks to show
in recently used.
You can select the number of
recently used workbooks list so that you can select a workbook you run often
without searching for it. You change
this setting to ‘9’.
3. Select [Query Governor] tab.
Summary Data: The data administrator creates
and refreshes summarized tables. Since the database is refreshed nightly, there
is no need to make a selection in the Summary Data area of this window.
Query Governor: You can cancel a query while it is running. We recommend you leave
Warning me when the limit
exceeds a certain number of seconds or minutes
Prevent a query from running longer
than a certain number of seconds or minutes.
Limit retrieved query data to
a certain number of rows
Retrieve data incrementally
in groups of a certain number of rows – no need to change
Cancel list of values
retrieval after a preset amount of time. – probably won’t need
4. Select [Sheet] tab.
Set your preference of layout
Column Headings, Row numbers,
If you are currently in a
table report, the Options dialog box has a Table tab
Two Style options are
available for crosstab layouts:
5. Select [Formats].
Set formatting for all future
worksheets, using the Format tab.
Title: You can create a new
title by default; the title will not appear in the current workbook, but will
appear in the next new workbook.
Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.
Oracle® Tutor Copyright © 1997, 2009, Oracle. All rights reserved.