Sql*Plus User’s Guide and Reference

Using Bind Variables
............................................................................................................................ 5-21
Creating Bind Variables ................................................................................................................. 5-21
Referencing Bind Variables............................................................................................................ 5-22
Displaying Bind Variables ............................................................................................................. 5-22
Using REFCURSOR Bind Variables
.................................................................................................. 5-22
Fetching Iterative Results from a SELECT inside a PL/SQL Block
............................................. 5-25
6
 Formatting SQL*Plus Reports
Formatting Columns
................................................................................................................................ 6-1
Changing Column Headings............................................................................................................ 6-1
Formatting NUMBER Columns....................................................................................................... 6-3
Formatting Datatypes........................................................................................................................ 6-4
Copying Column Display Attributes .............................................................................................. 6-7
Listing and Resetting Column Display Attributes........................................................................ 6-7
Suppressing and Restoring Column Display Attributes.............................................................. 6-8
Printing a Line of Characters after Wrapped Column Values .................................................... 6-8