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
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------------------------
alias sqlplus
alias sqlplus='uniread /opt/oracle/product/10.2/db_1/bin/sqlplus'
sqlplus
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
xxx>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/94384/viewspace-600287/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLPlusSQL
- sqlplus spoolSQL
- sqlplus sqlpromptSQL
- sqlplus用法SQL
- sqlplus -premliSQLREM
- sqlplus提示SQL
- sqlplus(一)SQL
- 如何在solaris的oracle sqlplus中使用sqlplusOracleSQL
- 【SQLPLUS】sqlplus 客戶端所需的檔案列表SQL客戶端
- SQLPLUS 操作大全SQL
- sqlplus的使用SQL
- 讓sqlplus 飛SQL
- sqlplus set命令SQL
- sqlplus 基礎SQL
- SQLPLUS COPY 功能。SQL
- sqlplus 命令大全SQL
- sqlplus-helpSQL
- sqlplus小記SQL
- windows sqlplus亂碼WindowsSQL
- sqlplus專用命令SQL
- sqlplus 使用總結SQL
- sqlplus column命令用法SQL
- sqlplus登陸方式SQL
- sqlplus 內部命令SQL
- sqlplus失去響應SQL
- sqlplus -prelim/ as sysdba用法SQL
- 隨筆 sqlplus / as sysdbaSQL
- rlwrap sqlplus in linuxSQLLinux
- 修改sqlplus的SQLPROMPTSQL
- SQLPLUS的ACCEPT命令SQL
- 常用sqlplus設定SQL
- sqlplus安裝helpSQL
- sqlplus help installSQL
- sqlplus set命令使用SQL
- sqlplus 顯示控制SQL
- SQLPLUS 的COPY命令SQL
- sqlplus與空行.txtSQL
- sqlplus 命令列格式SQL命令列