%ORACLE_HOME%\dbs下有一个文件login.sql,在这个文件里加上一句 SET LINESIZE 30 每次启动SQLPLUS后LINESIZE就自动设为30了。
把login.sql所在路径,配置到bin 路径里去,就行了
我的是oracle 10g ,具体在哪个目录,我没找到这个文件
那就自己创建一个,类似于目录 D:\oracle\product\10.2.0\db_1\dbs 也可能是c:或E:目录下:我的login.sql内容为set serveroutput on size 1000000 set trimspool on set long 5000 set linesize 1000 set pagesize 9999 column plan_plus_exp format a80 column global_name new_value gname set termout off define gname=idle column global_name new_value gnameSELECT lower(user) || '@' || substr(global_name, 1, decode(dot, 0, length(global_name), dot-1)) global_name FROM (SELECT global_name, instr(global_name, '.') dot FROM global_name);set sqlprompt '&gname> ' set termout on
SET LINESIZE 30
每次启动SQLPLUS后LINESIZE就自动设为30了。
D:\oracle\product\10.2.0\db_1\dbs
也可能是c:或E:目录下:我的login.sql内容为set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 1000
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gnameSELECT lower(user) || '@' ||
substr(global_name, 1, decode(dot, 0, length(global_name), dot-1)) global_name
FROM (SELECT global_name, instr(global_name, '.') dot FROM global_name);set sqlprompt '&gname> '
set termout on