Oracle Database Query and Reporting Form
The Database Query and Reporting form is a tool written in Forms 6i with which users can create queries on any tables or views in an Oracle database (on which they have select privileges) without having to write the SQL behind the query.
This is a useful reporting tool with which users who have limited knowledge of SQL can create and modify reports and dump the results into an Excel spreadsheet. Experienced SQL writers can also use it to store and run queries, and to easily output database data in spreadsheet format.
Select the view/table to base the query on, then select the column names from the drop down lists. Specify the conditions and the columns to order by, then click on 'Get Data'. The SQL behind this query is generated automatically:
(Checking the "Count report" box generates a 'Group By' report, with a 'count' column showing the numbers of each distinct row returned eg "SELECT SURNAME, COUNT(*) FROM SCOTT.PEOPLE GROUP BY SURNAME")
This SQL can be modified if required, or raw SQL can be entered directly into the form without having to use any of the drop down lists.
The data returned by the query can be previewed and then easily exported into Microsoft Excel:
The query can be stored in the database and retrieved later.
The form includes a help window, giving information on how to perform most common tasks.
The demo version of the spell checker includes the compiled version of this form (the .fmx), so it can be used to create queries, but the queries cannot be stored or retrieved.
Download a demo version of the Query Form and Spell Checker for evaluation.
The full version includes all the uncompiled code (the .fmb), so the form can be modified, and a script to create a table in the database with which queries can be stored and retrieved.
Buy it here, along with the Spell Checker, for $99.95 using a secure payment system.
Email any queries to: enquiries@woodyswebsite.co.uk