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: