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

最新推荐文章于 2026-08-21 11:30:00 发布

转载最新推荐文章于 2026-08-21 11:30:00 发布 · 166 阅读

收录于

当前文章被以下社区和专栏收录：

本文演示了如何使用Oracle10g企业版数据库通过SQL*Plus命令行工具查询当前系统日期。文中提供了具体的命令行操作步骤及输出结果，展示了在不同用户下执行相同查询命令的过程。

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

连接到:
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
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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94384/viewspace-600287/

标签

#数据库