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
- 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.
- 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
- 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.
- 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.
- To create an output file in the p:\sql directory:
- To quit SQL*Plus, type exit.