execute multiple sql files at once in command prompt
U:\>test.cmd U:\>( echo set serverout on echo @u:\test.sql echo @u:\test.sql ) | sqlplus user/pass@testdb SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 13 12:50:05 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production SQL> SQL> test PL/SQL procedure successfully completed. SQL> test PL/SQL procedure successfully completed. SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Pro duction With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production U:\>
No comments:
Post a Comment