Oracle修改提示符方法

文章由LinuxBoy分享于2019-03-30 10:03:49热评（294）

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

推荐文章：

Oracle修改提示符方法