pipe-out-from-a-sequence-of-commands to sqlplus
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博客 ” ，链接：https://blog.itpub.net/94384/viewspace-600287/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- Windows WMIC命令详解 (Windows Management Instrumentation Command-line)
- 为monitor打PSU4 (10.2.0.4.4)的步骤
- 重建控制文件 recreate control file
- 停库前执行alter system checkpoint 很重要!
- 参加oracle 数据中心优化高峰会
- 用RMAN迁移文件到ASM或从ASM迁出
- 常用sql
- 分区操作常用sql
- How to Get a 10046 trace for a Parallel Query [ID 1102801.1]
- Master Note Parallel Execution Wait Events [ID 1097154.1]
