Express data may be stored in hierarchies, or levels. By default, hierarchies
appear in reports with indents of two single-byte spaces. You can change
the type of characters that are used to fill indents and the size of indents
between levels of data by editing the xrpdsprefs.ora
file.
xrpdsprefs.ora
file, if it exists in the ORACLE_HOME/reports/jlib
directory.
If the file does not exist, then use a text editor to create xrpdsprefs.ora
.
Scroll to or create the options.hierarchy.indent.string
line.
This setting defines the indent character as a single-byte space. You can edit this setting for any keystroke character(s), such as asterisk (*) or dash (-). When editing, use quote marks around the character(s) of your choice:
options.hierarchy.indent.string="*"
Scroll to or create the options.hierarchy.indent.count
line.
This setting may be any integer from 0 though 10. A value of 0 turns off indenting. Values of 1 through 10 specify the number of single-byte characters to include in the indent. The default setting is 2.
Save your changes and close the file.
You can include the following sample settings in the xrpdsprefs.ora
file:
options.hierarchy.indent.string ="+ "
options.hierarchy.indent.count =4
The report output is formatted as follows:
Great Britain
+ + + + England
+ + + + + + + + London
+ + + + + + + + Salisbury
+ + + + Scotland
+ + + + + + + + Edinburgh
+ + + + + + + + Glasgow
United States
+ + + + California
+ + + + + + + + Los Angeles
+ + + + + + + + San Francisco
+ + + + + + + + San Jose
+ + + + Pennsylvania
+ + + + + + + + Philadelphia
+ + + + + + + + Pittsburgh
Copyright © 1984, 2005, Oracle. All rights reserved.