oracle提示符,Oracle修改提示符方法

￡神魔★判官ぃ 2023-01-18 15:29 197阅读 0赞

![5268f80b9b1e01f982625ef6fac83ca1.png][]

Oracle修改提示符方法sqlplus启动的时候会读取glogin.sql脚本，在$Oracle\_HOME/sqlplus/admin目录中，写在里面就可以了。给你个例

Oracle修改提示符方法

sqlplus启动的时候会读取glogin.sql脚本，，在$Oracle\_HOME/sqlplus/admin目录中，写在里面就可以了。

给你个例子。

\[php\]

\--

\-- NAME

\-- glogin.sql

\--

\-- DESCRIPTION

\-- SQL\*Plus global login startup file.

\--

\-- Add any sqlplus commands here that are to be executed when a user

\-- starts SQL\*Plus on your system

\--

\-- USAGE

\-- This script is automatically run when SQL\*Plus starts

\--

\-- For backward compatibility

SET SERVEROUTPUT ON SIZE 1000000

SET TRIMSPOOL ON

SET LONG 5000

SET LINESIZE 100

SET PAGESIZE 9999

SET SQLPLUSCOMPATIBILITY 8.1.7

COLUMN global\_name new\_value gname

SET TERMOUT OFF

select lower(user) || '@' || decode(global\_name,'Oracle8.WORLD','8.0','ORA8I.WORLD','8i',global\_name) global\_name from global\_name;

SET SQLPROMPT '&gname>'

SET TERMOUT ON

\-- Used by Trusted Oracle

COLUMN ROWLABEL FORMAT A15

\-- Used for the SHOW ERRORS command

COLUMN LINE/COL FORMAT A8

COLUMN ERROR FORMAT A65 WORD\_WRAPPED

\-- Used for the SHOW SGA command

COLUMN name\_col\_plus\_show\_sga FORMAT a24

\-- Defaults for SHOW PARAMETERS

COLUMN name\_col\_plus\_show\_param FORMAT a36 HEADING NAME

COLUMN value\_col\_plus\_show\_param FORMAT a30 HEADING VALUE

\-- Defaults for SET AUTOTRACE EXPLAIN report

COLUMN id\_plus\_exp FORMAT 990 HEADING i

COLUMN parent\_id\_plus\_exp FORMAT 990 HEADING p

COLUMN plan\_plus\_exp FORMAT a80

COLUMN object\_node\_plus\_exp FORMAT a8

COLUMN other\_tag\_plus\_exp FORMAT a29

COLUMN other\_plus\_exp FORMAT a44

\[/php\]

D:\\Temp>;sqlplus

SQL\*Plus: Release 9.2.0.4.0 - Production on Tue Dec 16 12:07:06 2003

Enter user-name: scott/tiger@ora921.hl3

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

Welcome to Seraphim's SQL\*PLUS!

You are connected to ORA921.IAGENT as SCOTT

SQL>;

实现这种效果，在glogin.sql中加入以下行：

set heading off

prompt Welcome to Seraphim's SQL\*PLUS!

select 'You are connected to ' || global\_name || ' as ' || user from global\_name;

set serveroutput on

set heading on

或

COLUMN host\_name new\_value hname

SET TERMOUT OFF

select SYS\_CONTEXT('USERENV','HOST') host\_name from dual;

SET SQLPROMPT '&hname>;'

SET TERMOUT ON

![logo.gif][]

![1428d0e076c3959ab11d28a39bc84fab.png][]

![5268f80b9b1e01f982625ef6fac83ca1.png][]

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网

[5268f80b9b1e01f982625ef6fac83ca1.png]: /images/20221021/dff1357a680c49f0aec923f60bd9f80c.png
[logo.gif]: https://www.gxlcms.com/linuxfile/logo.gif
[1428d0e076c3959ab11d28a39bc84fab.png]: /images/20221021/6d57a713f58841a984f99d6f1bf72ca2.png

oracle提示符,Oracle修改提示符方法

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 window 命令提示符修改颜色

相关 oracle提示符,Oracle修改提示符方法

相关 MySQL修改提示符（prompt）

相关 python 如何修改解释器提示符

相关 oracle提示符sqlprompt

相关 linux下.bashrc文件 /PATH环境变量修改 /提示符修改

相关修改MySQL提示符

相关修改Linux命令提示符

相关 cmd命令提示符使用

相关 MySQl 修改提示符