Using SQLPass-Though Queries for Banner Reporting

 by Bruce Knox
  bknox @t  
   Oracle Database Programmer/Analyst                                                                   date last updated 05/13/2009
              Copyright 2002 Cision Studios   Michelangelo Fubaloo      

Logon (Ours looks like the Banner Client Server Logon).

Logon with separate DSN and DBQ.    (MS vs. Oracle)

My Favorite BannerAccess Query.

Predefined Queries as Building Blocks.

Who's On Your Oracle Database?

Predefining all those Queries will take Forever!  Not really, you Let the Server Help.

Let Oracle Create your Code from the Data Dictionary.

Banner Reporting Requires All the Tools You Can Bring to the Task.  At some point you need the Oracle Guys!

This is mostly a series of screen prints with a bit of narrative.  This is how we set up BannerAccess and use it for Banner Reporting.


Back to BannerAccess


This is a personal site maintained by Bruce Knox ( bknox at ) documenting University of Arkansas, Division of Agriculture, Cooperative Extension Service IT projects. 

Use this information and these scripts at your own risk.
 As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences.  The scripts and information are provided "as is" without warranty, implied or otherwise.  Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:)

Any University of Arkansas Division of Agriculture website Disclaimer terms found in conflict with terms of this disclaimer shall over ride and replace the conflicting terms found herein.

Other personal pages/sites that I maintain: 
the website for the openMosix (Open Source) Project hosted on Logo.
Note:  The openMosix Project officially closed March 1, 2008.  The source code and mail lists archives will continue to be available on SourceForge as reference materials.  Archive Links are:  FAQ  HowTo Wiki  SourceForge

Most of the works of art on my pages other than the Extension banner
Book Dragon copyright 2006 J. Wilson Spenceare used by permission of J. Wilson Spence. is my personal site.  betwinx?  This site is largely oriented to Oracle Reporting Solutions in the context of generating bespoken reports from SunGard Higher Education's Banner product.  My university site is a more restrained version which cannot contain endorsements of products or companies.
(I maintain a number of special topic pages with links from this primary site.)                                 
View Bruce Knox's profile on LinkedIn  

Near mirror at which is my university work site.


mirror page: