The serveroutput parameter in Oracle sets the permanence method once
- 2020-11-30 08:37:21
- OfStack
serveroutput is the configuration parameter of sqlplus, not the database configuration parameter, modify and save the configuration parameters of sqlplus so that sqlplus does not have to be reset every time it is opened.
The setting method is as follows:
1. sql > set serveroutput on
And then, in sqlplus
2. sql > store set $ORACLE_HOME/sqlplus/admin/glogin.sql replace
Complete the save Settings.
The Settings can be viewed as follows:
SQL > show serveroutput;
serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
Indicates successful setup.
The setting method is as follows:
1. sql > set serveroutput on
And then, in sqlplus
2. sql > store set $ORACLE_HOME/sqlplus/admin/glogin.sql replace
Complete the save Settings.
The Settings can be viewed as follows:
SQL > show serveroutput;
serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
Indicates successful setup.