Chinaunix首页 | 论坛 | 博客
  • 博客访问: 124394
  • 博文数量: 27
  • 博客积分: 1200
  • 博客等级: 中尉
  • 技术积分: 350
  • 用 户 组: 普通用户
  • 注册时间: 2010-12-22 14:56
文章分类

全部博文(27)

文章存档

2011年(19)

2010年(8)

我的朋友

分类: Oracle

2010-12-30 21:41:49

    Note: You may wish to change the SQL*Plus prompt so that it
includes the name of the current instance. To do this you can issue a
SQL*Plus command such as the following:
SET SQLPROMPT '_CONNECT_IDENTIFIER> '
This command replaces the "SQL" string in front of the greater than
symbol (>) with the user variable _CONNECT_IDENTIFIER that will
display the current instance name for the duration of your current
session.
To change the prompt for all sessions automatically, add an entry
similar to the following entry in your glogin.sql file, found in the
SQL*Plus administrative directory:
SET SQLPROMPT '_CONNECT_IDENTIFIER> '
You may include any other required text or SQL*Plus user variable
between the single quotes in the command.
阅读(1376) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~