QA provides instant access with just a few mouse clicks to any table in any Oracle database. It is available here for anyone with access to any Oracle Forms version, from 6i through 10g.
QA is an essential tool for developers to view and modify data in their tables while testing and debugging Forms and database packages and triggers during development. QA is also useful for casual users who need to view and modify data in tables where a specific user interface is not available.
There is no fee or registration required to use QA.
Recent changes: QA works well in the Web Forms environment, with no compromise with its Client/Server behavior. It can be used in Client/Server Forms 6i as well as in Web Forms versions 6, 9 and 10.
A MRU (Most Recently Used) list of tables is available when you select a table to display, showing the last 30 tables accessed. In addition, if you enter a partial table name, a Like % query is used to display a list of matching tables.
Earlier versions were limited to accessing data with less than 4000 characters in the entire row. Now there is no limit, except that the number of columns accessible at one time remains limited to 100.
QA uses the Forms Exec_SQL package to interact with the database. Earlier versions used Oracle's DBMS_SQL package, which did not work correctly with all versions of Forms.
The drag-and-drop feature remains on the Description/Setup screen so you can rearrange the order of columns displayed by QA. (Unfortunately, this feature works only with Client/Server Forms 6i.) You can also use the Setup screen to change the default order-by used for your display, and to hide columns as well.