Custom Query Builder for Oracle using ASP

Category:
ASP, HTML and XML
Type:
Applications
Difficulty:
Intermediate
Author:
Alastair Vance

Version Compatibility: ASP

More information:
I developed this code for some of our more experienced users who understand how data is stored and are able to create their own reports.

I run this using a web browser control from within the main VB application. I used ASP and HTML, because I find it more flexible for this style of reporting.

This code should work on any Oracle Schema. I use OLEDB 8.1.6. to connect to Oracle. Make sure and set up your Schema name, oracle service name and password in the first file of the query builder (customreport.asp).

The username that the code uses to connect to the database needs permission to select from ALL_TABLES (Maybe all users can do this anyway?? - You could always hardcode the table list if this is not possible).

The data is displayed in a grid (which has several parameters that you can tweak).


Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download querybuilder.zip