1  SET_PAGE_LENGTH
   Used to size a page. Currently this is only used by the
   pagination control in the SQL HELP command.
 

2  Environment
   You can use the SET PAGE LENGTH (or SET PAGESIZE) statement:

   o  In interactive SQL

   o  Embedded in host language programs

   o  As part of a procedure in an SQL module or other compound
      statement

   o  In dynamic SQL as a statement to be dynamically executed
 

2  Format

 SET PAGE LENGTH -----> integer ------>
 

 

2  Examples

   This example uses the SET PAGE LENGTH command to change the
   pagination length of HELP.

   SQL> set page length 40;
   SQL> show display
   Output of the query header is enabled
   Output of the row counter is enabled
   Output using edit strings is enabled
   Page length is set to 40 lines
   Line length is set to 80 bytes
   Display NULL values using "NULL"