Home » SQL & PL/SQL » SQL & PL/SQL » SQL* Plus 3.3
SQL* Plus 3.3 [message #142] Fri, 18 January 2002 09:58 Go to next message
Messages: 92
Registered: August 1999
How can I print a line or any kind of separator between breaks in a report?


Re: SQL* Plus 3.3 [message #193 is a reply to message #142] Sat, 26 January 2002 06:59 Go to previous message
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.
Previous Topic: urgent..how do i return the resultset or cursor from oracle stored procedure
Next Topic: Re: UTL_FILE
Goto Forum:

Current Time: Thu Aug 06 09:11:14 CDT 2020