PLSQL

These instruction are great.
Thanks for putting the time into this.
Mark
503-816-2774 (Cell)
503-460-3336 (Home)
503-627-3008 (Desk)
mark.schofer@gmail.com (Alternative)

-----Original Message-----
From: Rendar, Byron [mailto:brendar@ex.oci.pcc.edu]
Sent: Tuesday, October 31, 2006 10:53 AM
To: Schofer, Mark
Subject: PL/SQL Class

Hi Mark,
Here's more information about the pl/sql class.
I will try to keep the database T3 up and running. If for some reason
it is not, or if isqlplus or the listener isn't running you will need to
log in and start things up.
Use putty to log into sherlock.pcc.edu (216.64.246.11) with login name
ora10103 and password 2gwnhgb4 (star trek saying).
I assume you know how to startup and shutdown the database (using
sqlplus). To start isqlplus type
isqlplusctl start
at a prompt.
To check the status of or start the listener:
lsnrctl status
lsnrctl start
Like the first class, there are two sets of books since the class
consists of two modules, PL/SQL Fundamentals and Develop PL/SQL Program
Units. You can give out just the Fundamentals book to start. IMPORTANT
- please tell the students not to open them if they think that they
might drop the class because they will be charged for the books.
This class, like the previous one has a reset.sql script which needs to
be run when the first module, PL/SQL Fundamentals ends and before you
start the 2nd module, Develop PL/SQL Program Units. The reset.sql
script is in the plsqllabs folder. Below is what the setup guide says.
(Note you may need to uncomment lines in the script, I haven't looked at
it.)
This course is comprised of two modules. The first module is Oracle
Database 10g: PL/SQL Fundamentals. The second module is Oracle Database
10g: Develop PL/SQL Program Units. When the first module ends (at the
end of the second day), the accounts need to be reset to match the
course material for the second module. These are the directions to reset
the course accounts for the second module.
1. On the Instructor machine only: Find the reset.sql file.
2. Drag the reset.sql file to the desktop.
3. The instructor is responsible for running the contents of the
reset.sql file once the first module ends (which should be at the end of
day three).
4. This script requires the instructor to know the sid and the
number of accounts to be reset. The instructor is prompted for this
information.
5. All users must be disconnected from the session in order for the
reset scripts to work.
6. The script is run from SQL*Plus and the working directory in
SQL*Plus must be set to the \labs\reset folder.
7. Once the information is provided, the accounts are automatically
rebuilt for the second module.
8. To test the account, issue the following SQL statement from one
of the reset accounts:
SELECT COUNT(*) FROM employees;
The result should be 107.