用交互方式登入 oracle instance

 

用交互方式登入 oracle instance:

#! /bin/sh
#! Author: Sheng Huiping
#! Date: July 6 2011
#! Function: To use the Oracle ID/ passwd to enter into the DataBase:

read word1?"please enter the Oracle ID: "
echo $word1
read word2?"please enter the ID passwd: "
echo $word2

sqlplus $word1/$word2@instancename

 注意： read 在 aix 和linux 上有些区别，具体用法可以google.