SqlPlus 环境设置

sqlplus 中退格删除：

1

vi .bash_profile

2

stty erase ^h

3

source .bash_profile

快捷命令：

1

su - oracle

2

vi .bashrc

3

``

4

alias OH='cd $ORACLE_HOME'

5

alias OB='cd $ORACLE_BASE'

6

alias sqlp='sqlplus / as sysdba'

7

alias expsid='_a(){ export ORACLE_SID=$1; };_a'

8

``

9

source .bashrc

10

OB

11

OH

12

expsid PROD

13

sqlp

sqlplus 显示设置：

1

vi /u01/app/oracle/product/11.2.0/dbhome_1/sqlplus/admin/glogin.sql

2

``

3

define _editor=vi

4

set sqlprompt '_user@&_CONNECT_IDENTIFIER>'

5

set line 999

6

set pagesize 999

7

set long 999

​