Oracle Forms data browser and AI-assisted code analyser
| EMP_ID | LAST_NAME | DEPT |
|---|---|---|
| 1001 | Andrews | SALES |
| 1002 | Mitchell✎ | HR |
| 1003 | Okafor | FINANCE |
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.
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.
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.
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.
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.
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.
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.
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:
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.
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.
Non-developers who support Oracle Forms applications can look up and correct records without knowing PL/SQL or the underlying table structure.
Understand which tables and columns a form touches without reading PL/SQL. Useful for schema migrations, access control reviews, and performance investigation.
"What table does this form use? What columns?" FormsXray-View answers that immediately — no Designer, no reading source code, just open the .fmb.
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.
Full functionality, no credit card required. Activate a license whenever you're ready.