SQTTEXT: A tool for editing Structured Query Language (SQL) text within ORACLE SQL*Forms applications

TL;DRAbstract

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

Chat with Paper

AI Agents for this Paper