我是在linux下的,脚本SQLPATH都设置好的。下面这段设置都起作用了,路径都设置没问题的。 define _editor=vi set serveroutput on size 1000000 set long 5000 set linesize 100 set pagesize 9999 column plan_plus_exp format a80 column global_name new_value gname set termout off define gname=SQL 关键是下面的、、
define gname=idle COLUMN global_name new_value gname select 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> '; SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 12月 26 12:50:35 2010Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining optionsscott@YPCOST>
windows环境下的9i版本,图形界面和命令行的sqlplus都正常。
define _editor=vi
set serveroutput on size 1000000
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=SQL 关键是下面的、、
define gname=idle
COLUMN global_name new_value gname
select 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> ';
SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 12月 26 12:50:35 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsscott@YPCOST>