oracle spool文件路径,spool找相对路径

C:\Users\lastwinner>sqlplus ****/****

SQL*Plus: Release 11.2.0.1.0 Production on 星期六 2月 16 14:49:59 2013

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

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

SQL> spool 2013-02-16.txt

SQL> select 1 from dual;

1

----------

1

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

会话已更改。

SQL> select sysdate from dual;

SYSDATE

-------------------

2013-02-16 14:51:07

SQL> spool off

SQL> host

Microsoft Windows [版本 6.1.7601]

版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\lastwinner>dir 2013-02-16.txt /s

驱动器 C 中的卷是 OS

卷的序列号是 7C4E-86D4

C:\Users\lastwinner 的目录

2013-02-16  14:51               657 2013-02-16.txt

1 个文件            657 字节

所列文件总数:

1 个文件            657 字节

0 个目录 51,417,817,088 可用字节

C:\Users\lastwinner>cd /d d:\oracle\

d:\oracle>sqlplus ****/****

SQL*Plus: Release 11.2.0.1.0 Production on 星期六 2月 16 14:53:13 2013

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

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

SQL> spool 2013-02-16_2.txt

SQL> select '2013-02-16_2' from dual

2  ;

'2013-02-16_

------------

2013-02-16_2

SQL> spool off

SQL> exit

从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options 断开

d:\oracle>dir 2013-02-16_2.txt