And commands are available the nonbrowser versions sql
Running a Script
Almost any statement that works interactively in SQL*Plus can be stored in a file for repeated execution. The easiest way to run such a script is to use the SQL*Plus @ com‐mand.4 For example, this runs all the commands in the file abc.pkg:
and you will get identical results. Either way, this command causes SQL*Plus to do the following:
1. Open the file named abc.pkg.
Package created.
Package body created.
SP2-0310: unable to open file "abc.sql"
As you can see, the default file extension is sql. By the way, the “SP2-0310” is the Oracle-supplied error number, and “SP2” means that it is unique to SQL*Plus. (For more details
SQL*Plus | | | 29 |
---|
C:\BOB\FILES> sqlplus
then any file operations inside SQL*Plus (such as opening or running a script) would default to the directory C:\BOB\FILES.
REM Filename: abc.pkg
@abc.pks
SQL> @/files/src/release/1.0/abc.pkg
SP2-0310: unable to open file "abc.pks"
30 | | |
---|