Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"set pagesize 0" no longer supported in 4.1?

Mat W.Jul 31 2015 — edited Aug 4 2015

Hi,

In 4.0.xxx, I could use "set pagesize 0" (along with a few others, such as "set feedback off") to produce spooled output that only included the table headers and output, nothing else.

In 4.1, I receive the following error: SP2-0267: pagesize option 0 out of range (2 through 50000)

Regardless... can someone please provide proper way to spool with nothing other than column headers on first line and data rows on following lines?

Apologies if I'm missing something obvious.

This post has been answered by thatJeffSmith-Oracle on Aug 3 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2015
Added on Jul 31 2015
8 comments
7,280 views