How to execute multiple sql files in DOS Windows

Answer:  You can execute many sql scripts and commands in Windows sql*plus by using this technique, using the "type" command to paste together all of the commands:

type C:\Users\Test\1.sql > c:\temp\runme.sql

type C:\Users\Test\2.sql >> c:\temp\runme.sql

sqlplus "/as sysdba" @C:\temp\runme.sql

Windows for the Oracle DBA The landmark book Windows for the Oracle DBA is a comprehensive overview of everything an Oracle DBA needs to know to manage Oracle on Windows.  Order directly from Rampant and save 30%.

Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Please  e-mail:   and include the URL for the page.                       Burleson Consulting The Oracle of Database Support Oracle Performance Tuning Remote DBA Services   Copyright © 1996 -  2023 All rights reserved by Burleson Oracle ® is the registered trademark of Oracle Corporation.