Break On problem in SQL*Plus
From: Schillinger <rz34_at_hp850.rz.uni-karlsruhe.de>
Date: 5 May 1993 07:09:35 GMT
Message-ID: <1s7p7f$5i3_at_nz12.rz.uni-karlsruhe.de>
Date: 5 May 1993 07:09:35 GMT
Message-ID: <1s7p7f$5i3_at_nz12.rz.uni-karlsruhe.de>
Background: Oracle v. 6.0.34.2.1
SQL*Plus v. 3.0.11.1.1 OS: HP/UX 9000 Series 800
Hi! I'm trying to do a BREAK ON key_field SKIP 1; in a SQL script. The funny thing is that is works just fine on the first page and then stops skipping! It keeps breaking, but won't skip any more (no matter if I set it to SKIP 1 or SKIP 5 or whatever).
I tried setting the pagesize to a huge number and then it skips for the whole report. But when I want to print, I'll need to set it back to something sensible.
Has anyone experienced this before or does anyone know what I could be doing wrong?
Thanks in advance!
Karen Schillinger
Schillinger_at_rz.uni-karlsruhe.de
or rz34_at_rz.uni-karlsruhe.de
Received on Wed May 05 1993 - 09:09:35 CEST