Skip to Main Content

SQL & PL/SQL

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!

Insert a blank line between records

102425Sep 25 2008 — edited Sep 26 2008
Hi,

I am creating a sqlplus report and want to insert a blank line or some seperator to seperate the records between the start and end points of the loop to make it more readable.


ex : The output currently look like this.
ColumnA       ColumnB
1                  2
2                  3
3                  1
4                  5
5                  6
6                  4
I want the output to look like this
ColumnA       ColumnB
1                  2
2                  3
3                  1

4                  5
5                  6
6                  4
Thanks for the help in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2008
Added on Sep 25 2008
8 comments
1,631 views