ITPub博客

首页 > Linux操作系统 > Linux操作系统 > pipe-out-from-a-sequence-of-commands to sqlplus

pipe-out-from-a-sequence-of-commands to sqlplus

原创 Linux操作系统 作者:tengrid 时间:2009-05-18 19:09:05 0 删除 编辑

C:\Documents and Settings\xxx>(
More? echo select sysdate from dual
More? echo /
More? echo exit
More? )|sqlplus
c2c/c2c@c2c

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 2月 5 15:02:51 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>   2
SYSDATE
--------------
05-2月 -07

SQL>

 

-------------------*inux------------------------
oracle@xxx>alias sqlplus
alias sqlplus='uniread /opt/oracle/product/10.2/db_1/bin/sqlplus'
oracle@xxx>unalias sqlplus                    <--- important for this test
oracle@xxx> (
> echo select sysdate from dual
> echo /
> echo exit
> )|sqlplus boss/boss

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 5 15:08:14 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>   2 
SYSDATE
------------
05-FEB-07

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
oracle@xxx>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/94384/viewspace-600287/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-18

  • 博文量
    136
  • 访问量
    381303