想在linux下写一个脚本,在脚本中实现对数据库的操作
但是希望能够提示用户输入数据库的用户名和密码该怎么写?尝试用了ACCEPT的方法 但是不行,不知道是不是写的不对ACCEPT username prompt Input database username:
ACCEPT passwd prompt Input database password:
conn username/passwd运行的时候直接就出结果了,没有让用户输入....
但是希望能够提示用户输入数据库的用户名和密码该怎么写?尝试用了ACCEPT的方法 但是不行,不知道是不是写的不对ACCEPT username prompt Input database username:
ACCEPT passwd prompt Input database password:
conn username/passwd运行的时候直接就出结果了,没有让用户输入....
Input database password:这2个都加了单引号的...
read username
ACCEPT passwd prompt Input database password:
read passwd
#Author:
#Version:
#Date:su - oracle <<EOF
sqlplus /nolog
ACCEPT username prompt 'Input database username:'
read username
ACCEPT passwd prompt ' Input database password:'
read passwd
conn &username/&passwd@&esid
update test set STATUS=0;
commit;
quit
exit
EOF
exit
还是不行
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 24 14:07:00 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> Input database username:SQL> Input database password:SQL> Enter value for esid: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SQL> SP2-0640: Not connected
read user
echo Input database password:
read passwd
sqlplus $user/$passwd@db_name在rehl5,oracle上测试通过
#Author:Sinpoal
#Label: test.sh
#Information: connect the database
#Create date:2010.10.15
#######################
#!/bin/bash
echo -e "Input database username:"
read username
echo -e "Input database password:"
read password
sqlplus $username/$password <<EOF
SQLSTATEMENT...
EOF;
exit 0;