SQL Plus - PAGES[IZE]

Card Puncher Data Processing

About

The system variable PAGES[IZE] sets the number of lines in each page.

Syntax

PAGES[IZE] {14 | n} embedded [ON|OFF]

Disable

set pagesize 0 embedded on

embedded on will let the first header appear.





Discover More
Card Puncher Data Processing
SQL Plus - Column Headers

Column header management The system variable heading controls the visibility of the headers The system variable pagesize will suppress the headers if it's set to 0. To avoid this behaviour,...
Card Puncher Data Processing
SQL Plus - Csv Export

How to export a CSV with SQL Plus. Export of the tables all_objects where:
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...
Card Puncher Data Processing
System Variable

s Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus will fetch...



Share this page:
Follow us:
Task Runner