CodePudding user response:

 

C: \ & gt; Echo the select object_id from user_objects where rownum ^ & lt;=5;> SQL 
 the test.
C: \ & gt; SQL 
 the type test.The select object_id from user_objects where rownum & lt;=5; 

C: \ & gt; The type of ABC. TXT 
System cannot find the specified file, 

C: \ & gt; Up sqlplus "/as sysdba" 

SQL * Plus: Release 11.2.0.4.0 Production on Thursday, March 22 15:25:38 2018 

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


To connect to: 
Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit 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> The exit 
From the Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0-64 - bit Production 
With the Partitioning, OLAP, Data Mining, and Real Application Testing options disconnect 

C: \ & gt; The type of ABC. TXT 
SQL> @ c: \ test. SQL; 

OBJECT_ID 
-- -- -- -- -- -- -- -- -- -- 
44150 
56752 
22530 
42062 
20058 

SQL> Spool off 

C: \ & gt;