[oracle@kook bin]$ cat test.sh
sqlplus -S "/ as sysdba" << !
select to_char(sysdate,'yyyy-mm-dd') today from dual;
exit;
!
执行结果
[oracle@test scrip]$ sh time.sh
TODAY
----------
2010-08-01
如果去掉S参数，执行结果如下
[oracle@test scrip]$ sh time.sh
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 1 16:08:59 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
TODAY
----------
2010-08-01
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
以上是去掉S参数的输出结果
还可以这样写
[oracle@kook bin]$ cat test.sh
sqlplus -S << !
conn / as sysdba
select to_char(sysdate,'yyyy-mm-dd') today from dual;
exit;
!
在用ftp命令时也有类似的对应参数“-n”.
sqlplus -S "/ as sysdba" << !
select to_char(sysdate,'yyyy-mm-dd') today from dual;
exit;
!
执行结果
[oracle@test scrip]$ sh time.sh
TODAY
----------
2010-08-01
如果去掉S参数，执行结果如下
[oracle@test scrip]$ sh time.sh
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 1 16:08:59 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
TODAY
----------
2010-08-01
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
以上是去掉S参数的输出结果
还可以这样写
[oracle@kook bin]$ cat test.sh
sqlplus -S << !
conn / as sysdba
select to_char(sysdate,'yyyy-mm-dd') today from dual;
exit;
!
在用ftp命令时也有类似的对应参数“-n”.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16566331/viewspace-670106/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
shell执行oracle sql脚本
下一篇：
一个bonding的脚本
请登录后发表评论
登录
全部评论
