Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Tip of the Month
July's Tip of the Month!
On Oracle Release 7.3 and above, the SET SERVEROUTPUT command has an undocumented option of FORMAT WRAPPED. When you specify this option, output from the DBMS_OUTPUT.PUT_LINE procedure will wrap to the SQL*Plus line size and leading blanks will not be trimmed. Example:
SET SERVEROUTPUT ON SIZE 10000000 FORMAT WRAPPED New tips will be added each month to the "PL/SQL Pipeline" - an online community for PL/SQL developers hosted by RevealNet. You can find it at http://www.revealnet.com/plsql-pipeline
The "PL/SQL Pipeline" is hosted by PL/SQL author Steven Feuerstein and includes several areas of interest:
You are invited to join the "PL/SQL Pipeline" - and we encourage your participation.
Best wishes,
Cam White
RevealNet, Inc.
(800) 738-3254
(202) 234-8557
http://www.revealnet.com
Received on Mon Jul 21 1997 - 00:00:00 CDT