Skriptář - Knihy, Skriptá a více pro vás

Listing the Buffer Contents............................................................................................................... 5-3 Editing the Current Line ................................................................................................................... 5-4 Appending Text to a Line ................................................................................................................ 5-5 Adding a New Line............................................................................................................................ 5-6 Deleting Lines .................................................................................................................................... 5-7 Placing Comments in Scripts ................................................................................................................. 5-7 Using the REMARK Command ....................................................................................................... 5-7 Using /*...*/ ........................................................................................................................................ 5-7 Using -- ................................................................................................................................................ 5-8 Notes on Placing Comments ............................................................................................................ 5-8 Running Scripts ..................................................................................................................................... 5-10 Running a Script as You Start SQL*Plus...................................................................................... 5-10 Nesting Scripts ....................................................................................................................................... 5-11 Exiting from a Script with a Return Code ........................................................................................ 5-11 Defining Substitution Variables ........................................................................................................ 5-11 Using Predefined Variables ................................................................................................................. 5-12 Using Substitution Variables .............................................................................................................. 5-12 Where and How to Use Substitution Variables.......................................................................... 5-12 Avoiding Unnecessary Prompts for Values ................................................................................ 5-14 Restrictions ...................................................................................................................................... 5-17 System Variables ............................................................................................................................. 5-17 Passing Parameters through the START Command ....................................................................... 5-17 Communicating with the User ............................................................................................................ 5-19 Receiving a Substitution Variable Value .................................................................................... 5-19 Customizing Prompts for Substitution Variable ....................................................................... 5-20 Sending a Message and Accepting Return as Input .................................................................. 5-21 Clearing the Screen ......................................................................................................................... 5-21 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

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 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 Using Multiple Spacing Techniques............................................................................................. 6-11

v