Useful pl/sql script


pl/sql is the scripting language we use for oracle. There are two main ways to execute a pl/sql script. You can execute it from the command line like:

>sqlplus name/passwd@cdfonprd < script.sql

Or if you have a script which takes arguments log onto sql:

>sqlplus name/passwd@cdfonprd

and then do:

SQL> @ script arg1 arg2 ...

The linked script below is an example pl/sql script. This particular script takes a CID as an argument (so you have to use the 2nd way to run it).

Here is the script

Here is some pl/sql documentation

Here are some links to some other script pages with example scripts which do other things: