Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
and commands are available the nonbrowser versions

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 |

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Jesse Horn

PageId: DOC8D6A434