SQTTEXT: A tool for editing Structured Query Language (SQL) text within ORACLE SQL*Forms applications
SQTTEXT is an ORACLE SQL*Forms application that allows a programmer to view and edit all the Structured Query Language (SQL) text for a given application on one screen. This application is an outgrowth of the prototyping of an on-line system dictionary for the Worldwide Household Goods Information System for Transportation-Modernization decision support system being prototyped by the Oak Ridge National Laboratory, but it can be applied to all SQL*Forms software development, debugging, and maintenance. The system dictionary and SQTTEXT were written in version 2.3 of ORACLE's application generator, SQL*Forms. SQL*Forms greatly simplifies users' access to ORACLE databases, but the design of the tool should be friendlier to those programming, debugging, and maintaining SQL*Forms applications. Because SQL*Forms version 2.3 forces the programmer to view each component of a program through a window specific to that component, it is impossible to get an overview of the whole application at one time. The SQTTEXT application allows experienced ORACLE programmers to increase their productivity by allowing access to all Structured Query Language (SQL) text within a SQL*Forms application via one screen. The SQTTEXT application is based on the eight ORACLE Integrated Application Processor (IAP) tables that store information about SQL*Forms applications. The SQTTEXT application displays the trigger level, trigger name, and SQL text associated with triggers, and also displays block names, base table names, and the SQL text for WHERE/ORDER BY clauses. This report provides a step-by-step explanation of how to use SQTTEXT, descriptions of the IAP tables, and a listing of the SQTTEXT code.
- Research Organization:
- Oak Ridge National Lab. (ORNL), Oak Ridge, TN (United States)
- Sponsoring Organization:
- USDOD
- DOE Contract Number:
- AC05-84OR21400
- OSTI ID:
- 6445416
- Report Number(s):
- ORNL/TM-11639; ON: DE91000534
- Country of Publication:
- United States
- Language:
- English
Similar Records
Tool For Editing Structured Query Language Text Within ORACLE Forms Applications
Building a user interface using SQL*Forms and an intermediate table
Related Subjects
MILITARY EQUIPMENT
DATA BASE MANAGEMENT
TEXT EDITORS
S CODES
COMPUTER ARCHITECTURE
COMPUTER PROGRAM DOCUMENTATION
PROGRAMMING LANGUAGES
TRANSPORT
COMPUTER CODES
EQUIPMENT
MANAGEMENT
990200* - Mathematics & Computers
990300 - Information Handling