| SQL* Plus 3.3 [message #142] |
Fri, 18 January 2002 09:58  |
Dave
Messages: 92
Registered: August 1999
|
Member |
|
|
How can I print a line or any kind of separator between breaks in a report?
Thanks,
Dane
|
|
|
|
| Re: SQL* Plus 3.3 [message #193 is a reply to message #142] |
Sat, 26 January 2002 06:59  |
reddwarf
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
Try the PROMPT statement.
When in a PL/SQl block, RDBMS_OUTPUT.PUTLINE works too but than you must specify a non blanc character between the single quotes. Never specify an empty string or just spaces because RDBMS_OUTPUT can not handle blanc lines. Afterwards you can use AWK or SED to replace the seperator characters with blancs.
Another thing you can do is use the supplied package UTL_FILE. This enables you to write data to a text file from within a PL/SQL block or stored procedure. It accepts lines which are empty or just spaces.
I know that in SQL*plus it is possible to define breaks. I propose you check the manual for that.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
