Used to size a page. Currently this is only used by the
pagination control in the SQL HELP command.
1 – 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
(B)0[m[1;4mSET[m[1m [1;4mPAGE[m[1m [1;4mLENGTH[m[1m qqqqq> integer qqqqqq> [m [1m [m
3 – 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"