Views expressed here are solely that of my own. Please make sure that you test the code/queries that appear on my blog before applying them to the production environment.

Thursday, April 12, 2007

Sqlplus - pagesize

Everyday we learn something new about Oracle databases that we missedbefore or may be we did not needed. Below is one of them for me, but Iused it recently in a Unix script to generate an Sqlplus report. Ipublish it here so that there may be others that missed the samepoint.

Maximum value of the Sqlplus pagesize parameter that you can set is 50000.

set pagesize 50000

No comments: