To Run a SQL Script Using the Command-line isql Tool
Go Up to Running a SQL Script
You can run a script from any console prompt using the -input
option to isql. Specify the full path and filename. In the following example, the script does not contain a CREATE DATABASE
statement; it runs against an existing database:
isql database_name -input filename
The following example runs a script that creates a database:
isql -input filename
During an active isql
session in which you are already connected to a database, you use the INPUT
command to read and execute a SQL script against that database:
SQL> INPUT filename
See Invoking isql for more about running isql
.