Expert: Peter Choi - 7/31/2006

Question
Hi, one more question,

We usually use the following syntax to run a SQL script file within SQL*Plus, is there other ways to achieve this? (for example, in DB2, we can use the command: db2 -tf createdb.db2)

SQL >  @/oracle/scripts/script.sql

Thanks,
lzzzz

Answer
Hi there,

from the command line, you can also issue a sqlplus <user>/<password>@<Oracle_sid> <script.sql>.

This can easily be used for batch scheduling on both Windows or Unix platform. This assumes, as in your DB2 example, that the path to the executable is set. Otherwise you will need to include the path where the SQLPLUS.EXE (or sqlplus on unix) is loacted.

Hope this helps.

Peter