SQL*Plus

Overview

The Oracle SQL*Plus Desktop client allows you to create and run Oracle SQL*Plus scripts against the Banner database.

Accessing the SQL*Plus Desktop Client

You may access the SQL*Plus Desktop client from your desktop by clicking on the SQL Plus desktop shortcut.  If you do not have a shortcut on your desktop, contact your IT Coordinator to have the software installed.

Using the SQL*Plus Desktop Client

1. Log into SQL*Plus
   • Click on the SQL Plus desktop shortcut.
   • Enter  your banner username in the format of username@database (i.e. mcclendj@PROD)
     PROD = Production database
     PPRD = Pre-production database
     DEVL = Development database
     TEST = Test database
     TRNG = Training database
     BILD = Build database
   • Enter your Banner password and hit Enter.  Note: When you enter your password, the cursor will not move and the password will not display.
2. Running SQL*Plus Files
   • The default directory is P:\SQL.
   • To run an existing sql file out of the P:\SQL directory:
     @filename
   • To run an existing sql file out of the P:\SQL directory on the Remote Desktop server:
     @P:\SQL\filename
   • To run a sql file out of a sub-directory within the sql directory:
     @subdirectory\filenanme.sql
   • To run a sql file out of a different directory or if running SQL*Plus from the Remote Desktop, use the full path in the command:
     @s:\it\filename.sql
3. Editing SQL*Plus Files
   • To edit the sql query/file in the current SQL*Plus window, type edit. This will open Notepad and allow you to edit what is in the buffer (afiedt.buf). Saving and closing Notepad will send it back to the SQL*Plus session.
   • You may use the Notepad or WordPad editor outside of the SQL*Plus desktop client to create or update sql files that can then be run using the SQL*Plus desktop client.
4. Creating Output Files
   • To create an output file in the p:\sql directory:
     spool filename
   • To create an output file in a sub-directory within the sql directory:
     spool subdirectory\filename
   • To create an output file in a different directory or if running SQL*Plus from the Remote Desktop, use the full path name in the command:
     spool s:\it\filename
   • Type spool off to stop saving the output.
5. To quit SQL*Plus, type exit.