Skip Navigation

Southern Oregon University

Banner Systems

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 shorcut 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@souprd)
      souprd = production database
      souupg = upgrade database 
      soutst = test database
    • Enter your Banner password.
  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 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.

Help

For additional help, please call the Faculty & Staff Help Desk at 552-6900 or email banner@support.sou.edu.