Sql*Plus User’s Guide and Reference


Clarifying Your Report with Spacing and Summary Lines


Download 5.34 Mb.
Pdf ko'rish
bet9/103
Sana04.08.2023
Hajmi5.34 Mb.
#1665146
1   ...   5   6   7   8   9   10   11   12   ...   103
Bog'liq
E18404-12

Clarifying Your Report with Spacing and Summary Lines
............................................................. 6-9
Suppressing Duplicate Values in Break Columns...................................................................... 6-10
Inserting Space when a Break Column's Value Changes.......................................................... 6-10
Inserting Space after Every Row................................................................................................... 6-11


vi
Using Multiple Spacing Techniques............................................................................................. 6-11
Listing and Removing Break Definitions .................................................................................... 6-12
Computing Summary Lines when a Break Column's Value Changes.................................... 6-12
Computing Summary Lines at the End of the Report ............................................................... 6-15
Computing Multiple Summary Values and Lines ..................................................................... 6-16
Listing and Removing COMPUTE Definitions .......................................................................... 6-17
Defining Page and Report Titles and Dimensions
......................................................................... 6-17
Setting the Top and Bottom Titles and Headers and Footers................................................... 6-18
Displaying System-Maintained Values in Titles ........................................................................ 6-21
Listing, Suppressing, and Restoring Page Title Definitions ..................................................... 6-22
Displaying Column Values in Titles ............................................................................................ 6-23
Displaying the Current Date in Titles .......................................................................................... 6-24
Setting Page Dimensions................................................................................................................ 6-24

Download 5.34 Mb.

Do'stlaringiz bilan baham:
1   ...   5   6   7   8   9   10   11   12   ...   103




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling