abc.txt為什么一直為空
uj5u.com熱心網友回復：
C:\>echo select object_id from user_objects where rownum ^<=5; > test.sql
C:\>type test.sql
select object_id from user_objects where rownum <=5;
C:\>type abc.txt
系統找不到指定的檔案。
C:\>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on 星期四 3月 22 15:25:38 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
連接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> spool c:\abc.txt
SQL> @c:\test.sql;
OBJECT_ID
----------
44150
56752
22530
42062
20058
SQL> spool off
SQL> exit
從 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 斷開
C:\>type abc.txt
SQL> @c:\test.sql;
OBJECT_ID
----------
44150
56752
22530
42062
20058
SQL> spool off
C:\>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/70811.html
標籤：開發