Double-click the tablename to view a description of the table. Double-click a column to view the first 100 distinct values for that column. Use the bottom field to search the current table for the occurrence of a char, number or date. Also uses the user defined where clause if any. Use explain plan to optimize queries, don't include a semicolon at the end of the query.
Stores results in recordgroups.
Search table for value code creates a query for each column in the table. Does data conversions when possible otherwise exception clause hides errors.