Running a SQL Query Against Banner Data

Summary

How to run a SQL query against Banner

Body

Issue/Question

I need to run a SQL query against Banner data in one of the available environments

Environment

  • Banner, Banner TEST, Banner ODS

Resolution

  1. Open PL/SQL Developer 
  2. Log into PROD Banner, TEST Banner, Prod Banner ODS, or Test Banner ODS as appropriate
  3. Open a new SQL window
  4. Copy and paste the SQL query into the SQL window
  5. Run the query by pressing F8
  6. The results will be displayed in the window below the query

Details

Details

Article ID: 5190
Created
Thu 6/18/20 3:46 PM
Modified
Tue 8/10/21 3:39 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated