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.
8/7/2015 04:04:37 pm

not satisified


Leave a Reply.