Setting The SQLPlus Page And Row Size In Oracle

In Oracle, the default page and line size settings for SQLPlus are 14 lines per page and 80 characters per line respectively. This can make viewing large result sets difficult when using SQLPLus.

Fortunately, these settings can easily be changed using the SET command:

set linesize 1000
set pagesize 1000

Executing these commands however only changes the settings for the current instance of SQLPlus. The next time you run it, the values default back to their original values. If these settings are placed in a file calledlogin.sql in the current working directory however, they will be loaded when SQLPlus starts.