FormsXray-View

Oracle Forms data browser and AI-assisted code analyser

Windows 10/11 x64  ·  30-day free trial
EMP_BLOCK → EMPLOYEES
EMP_ID LAST_NAME DEPT
1001 Andrews SALES
1002 Mitchell✎ HR
1003 Okafor FINANCE
Save 1 unsaved change

Data browser and AI code analyser — in one tool

Think of FormsXray-View as a SQL client that already knows your schema — because it read it from the .fmb. Open a form, connect to Oracle, and start querying. Column labels, ordering, and master/detail relationships are all pulled from the form definition automatically.

The built-in Analyze tab brings AI to your form code. Use it to explain complex triggers in plain English, detect potential bugs before deployment, identify duplicate or dead code, recommend Oracle Forms best practices, and generate developer documentation — all from the .fmb, without touching Oracle Designer.

The form is your schema guide

Open any .fmb and the left panel immediately lists all database-backed blocks with their underlying table names. Select a block to see column headers — before you even run a query — so you know exactly what you're working with.

  • All database blocks and table names visible at a glance
  • Column headers (labels from the form) shown before querying
  • Oracle Forms master/detail relations shown as tabs automatically
  • Supports multiple Oracle Forms installations via the Oracle Home selector
FormsXray-View block browser showing form metadata and database blocks
FormsXray-View query results grid showing Oracle data from form blocks

Query, edit, and navigate — all from the form

Select a block, type an optional WHERE clause, and click Execute. Results appear in an editable grid — double-click any cell to change it, then save with one click. Master/detail relationships from the form load as tabs automatically.

Querying

  • Optional WHERE clause filter
  • ORDER BY from the block definition
  • Tables, views, DISTINCT/GROUP BY/JOINs
  • Handles LONG, XMLTYPE, INTERVAL
  • Saved connection profiles

Editing & Saving

  • Double-click any cell to edit
  • Tables: saved via Oracle ROWID
  • Views: saved via original values
  • Full transaction — commit or rollback
  • Specific constraint error hints

Master / Detail

  • Detail blocks appear as tabs below the master grid
  • Selecting a master row auto-queries all related detail blocks
  • Multi-level master/detail chains supported
  • Resizable splitter between master and detail panels

Understand, validate, and document your forms

The Analyze tab goes beyond data browsing. Validate your form against the live database, then let AI work through the code — explaining what it does, spotting problems, and generating documentation — all without leaving FormsXray-View.

Export JSON

Creates a structured JSON export of the form — blocks, items, triggers, program units, and relations — ready to feed into any AI of your choice for custom analysis or documentation tasks.

Check Forms Data Types

Compares each form item's data type and maximum length against the actual database column definition. Highlights mismatches that could cause truncation errors or silent data loss at runtime.

Summarize Form

Sends the form's JSON to your configured AI provider and returns a plain-English summary: what the form does, how it is structured, what each major block and trigger is responsible for. Useful for onboarding and handover documentation.

AI Code Analysis

Send your form's trigger and program unit code to your AI provider and get back a thorough, plain-English analysis. Here's what it does for you:

  • Explain complex triggers in plain English
  • Detect potential bugs before deployment
  • Suggest code improvements
  • Recommend Oracle Forms best practices
  • Find duplicate logic across triggers
  • Identify dead or unreachable code
  • Generate developer documentation
  • Help new developers understand legacy applications

Works with the AI you already use

The AI features in the Analyze tab send your form's JSON to your chosen provider using your own API key. You pick the model, you control the cost — FormsXray-View never proxies your data through our servers.

Anthropic
Claude Opus, Sonnet, Haiku
OpenAI
GPT-4o, GPT-4, and more
Your API key, your model. You specify the model name directly in FormsXray-View — so you're never locked to whatever version we ship with. When a better model is released, just type it in.

For everyone who supports Oracle Forms apps

Developers fixing data bugs

Query and fix bad records while the form is open in Designer — without writing SQL from scratch. You already know the form, now you can see the data through the same lens.

Support staff & analysts

Non-developers who support Oracle Forms applications can look up and correct records without knowing PL/SQL or the underlying table structure.

DBAs supporting Forms teams

Understand which tables and columns a form touches without reading PL/SQL. Useful for schema migrations, access control reviews, and performance investigation.

Schema discovery

"What table does this form use? What columns?" FormsXray-View answers that immediately — no Designer, no reading source code, just open the .fmb.

Migration planning

Before migrating a form to a modern stack, use AI to produce a comprehensive plain-English description of its logic — a specification to build from rather than reverse-engineer.

Try FormsXray-View free for 30 days

Full functionality, no credit card required. Activate a license whenever you're ready.