#!/usr/bin/expect
spawn scp /home/test.sh root@127.0.0.1:/home/testabc.sh
expect "*assword*"
send "admin/r"
spawn su - oracle
expect "oracle@*"
send "sqlplus /nolog/r"
expect "SQL>"
send "conn / as sysdba/r"
expect "Connected."
send "select * from tab;/r"
expect "*rows selected."
send "exit;/r"
expect "SQL> Disconnected from Oracle Database*"
send "exit/r"
expect {eof}