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.