Home > Database > Mysql Tutorial > Oracle中serveroutput参数一次设置永久保存方法

Oracle中serveroutput参数一次设置永久保存方法

WBOY
Release: 2016-06-07 17:55:47
Original
1273 people have browsed it

serveroutput是sqlplus的配置参数,而不是数据库的配置参数,每次都需要修改并保存sqlplus的配置参数,本文将介绍如何一次设置永久保存

serveroutput 是sqlplus的配置参数,而不是数据库的配置参数,修改并保存sqlplus的配置参数,那么每次打开sqlplus时就不用重新设置了。
设置方法如下:
1. sql> set serveroutput on
然后,在sqlplus中
2. sql> store set $ORACLE_HOME/sqlplus/admin/glogin.sql replace
完成保存设置.
可以通过如下查看设置效果:
SQL> show serveroutput;
serveroutput ON SIZE UNLIMITED FORMAT WORD_WRAPPED
说明设置成功。
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template