Symbols | A | B | C | D | E | F | G | H | I | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

Index: L

• procedure
• • Supporting many data combinations
  • Using the l Procedure
  • Controlling Output from p
  • overloadings of : The overloadings of the l procedure
• last_line variable : Showing code just once
• lastsp function : Managing savepoints
• lava lamp effect : Lava Lamp Code Consolidation
• layering packages : Modularizing for Maintainable Packages
• layers, code : (see packages)
• least-recently used (LRU) algorithm : Managing packages in shared memory
• libraries
• • The Client-Side Layers
  • Prebuilt Packages
• lifo constant : Package constants
• limit_ps procedure : Setting the Page Size
• line function
• • Reading from a file
  • Reading the nth Line
• line limit, WHERE clause : Setting a Line Limit
• line numbers, code : Displaying Source Code
• line prefix : Setting the line prefix
• line procedure
• • Case-converting programs
  • Converting a line
• line separator
• • Setting the line separator
  • The Line Separator
• line_type record : Package records
• line_with function : Managing the source WHERE clause
• lines, changing case of : Converting a line
• linesep function
• • Setting the line separator
  • The Line Separator
• list of bailout errors : Managing the bailout error list
• list_full exception : Package exceptions
• list_undefined exception : Package exceptions
• lists : PLVlst: List Manager
• lists, copying files to
• • Copying a file
  • Copying File to List
• literals
• • Remove hard-coded literals from your application
  • Obliterating the Literals
  • PLV package : The Predefined Constants
  • user awareness of : Avoiding Need for User to Know and Pass Literals
• load_from_dbms procedure
• • Managing and accessing message text
  • Batch Loading of Message Text
  • Implementing load_ from_dbms
• loading message text : Batch Loading of Message Text
• log procedure : Using put_line
• logging
• • Changing Package Behavior Without Changing the Application
  • PLVlog: Logging Facility
  • PLVlog and PLVtrc: Logging and Tracing
  • Using put_line
  • commit activity : Logging commit activity
  • commits : Logging Commits
  • errors : Logging errors
  • exceptions
  • • Logging exception-handling activity
    • Recording the exception
  • hard-coding with exceptions : Drawbacks of the usual handlers
  • rollbacks
  • • Logging rollback activity
    • Logging Rollbacks
  • trace activity : Writing to the PL/Vision log
  • trace messages : Directing Output from PLVtrc
• logging function : Directing Output from PLVtrc
• logic, conditional
• • Conditional Logic
  • Conditional Logic
• login.sql file : PL/Vision Initialization Script for SQL*Plus
• logtype function : Selecting the log type
• loopexec procedure
• • Programmatic cursor FOR loop elements
  • Programmatic Cursor FOR Loop
• loops
• • Loops
  • Loops
  • Using Effective Coding Style for Packages
• LPAD function : Considering Implementation Options
• LRU (least-recently used) algorithm : Managing packages in shared memory