2.3. Saving and Running the Script

Save our script to a text file named examples.sql.

Now you have three choices: you can

• download the ready-made script files using the following links:

  • https://github.com/sim1984/example-db_2_5/archive/1.0.zip

  • or https://github.com/sim1984/example-db_3_0/archive/1.0.zip

• OR run the script examples.sql that you just created yourself;

• OR download the ready-made database, complete with sample data. Links are provided at the end of this chapter.

Now, to run our script in the database created earlier:

isql -user sysdba -password masterkey "localhost:examples"
         -i "d:\examples-db\examples.sql"

The argument "localhost:examples" uses an alias in place of the file path. It assumes that an alias named ‘examples’ actually exists, of course! The -i switch is an abbreviation of -input and its argument should be the path to the script file you just saved.