Hi,大家好,我是编程小6,很荣幸遇见你,我把这些年在开发过程中遇到的问题或想法写出来,今天说一说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
上一篇
已是最后文章
下一篇
已是最新文章