SERVEROUTPUT (Oracle8 Syntax) |
SERVEROUT[PUT] {ON | OFF} [SIZE n] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}] |
Controls whether or not SQL*Plus displays the output of stored procedures or PL/SQL blocks executed from the SQL*Plus prompt. Such output is most often generated by the DBMS_OUTPUT.PUT_LINE procedure.
Keywords
ON
Displays the output.
OFF
Suppresses the output of DBMS_OUTPUT.PUT_LINE. This option is the default.
SIZE
Sets the number of output bytes that can be buffered within the server. The default for n is 2000, and n must be between 2000 and 1,000,000.
WRAPPED
Specifies that output is to be wrapped within the current linesize. Line breaks can occur in the middle of words.
WORD WRAPPED
Specifies that output is to be word-wrapped within the current linesize. Line breaks will occur between words.
TRUNCATED
Specifies that any line longer than the linesize will be truncated.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.