Prompts
Tested prompts for Oracle work
120+ prompts for APEX, PL/SQL, Forms and SQL — 15 free, the rest in the Prompt Pack ($59 one-time, Gumroad).
APEXFree
Generate an APEX page from a table
You are an Oracle APEX 26.1 expert. Given this table DDL: <PASTE CREATE TABLE>, design an APEX page with an Interactive Report plus a modal form to create/edit rows. List the regions, items, and processes to create, the validations needed, and the exact steps in Page Designer.
APEXFree
Vibe-code with APEXLang
Using the APEXLang file structure in this folder, modify page <N> to add <CHANGE>. Edit only the relevant .apx files, keep IDs stable, and tell me which files changed so I can sync back to the cloud.
APEXFree
Write a PL/SQL process for a page
Write a PL/SQL process for an APEX page that <DOES X>. Use bind variables for page items (:Pn_ITEM), handle no-data and exceptions, and return a clear apex_error message on failure.
PLSQLFree
Refactor PL/SQL safely
Refactor this PL/SQL for readability and performance WITHOUT changing behavior: <PASTE CODE>. Explain each change, flag any side-effects, and keep the same signature.
PLSQLFree
Generate a package spec + body
Generate an Oracle package spec and body for these requirements: <REQUIREMENTS>. Include input validation, exception handling, and concise comments. Follow <NAMING CONVENTION>.
PLSQLFree
Write utPLSQL unit tests
Write utPLSQL unit tests for this procedure: <PASTE>. Cover happy path, boundary values, null inputs, and the exceptions it raises.
DocsFree
Explain & document legacy PL/SQL
Explain what this legacy PL/SQL does in plain <English/Arabic>, list its inputs/outputs and dependencies, and note risks before modernizing: <PASTE>.
FormsFree
Reverse-engineer a Forms module
Act as an Oracle Forms→APEX migration analyst. From this module export <PASTE FMB XML / description>, extract a structured blueprint: blocks, items, LOVs, triggers (with their PL/SQL), program units, and the business rules. Output as a table.
FormsFree
Map Forms to APEX + risks
For each Forms object in this blueprint <PASTE>, propose the equivalent Oracle APEX 26.1 component, note what has no direct equivalent, and rank migration risk (low/med/high) with mitigation.
SQLFree
Natural language → safe SQL
Given this schema <PASTE TABLES>, write a READ-ONLY Oracle SQL query for: <QUESTION>. Use only listed tables/columns, add no DML, and explain the query.
SQLFree
Tune a slow query
Analyze this query and its execution plan <PASTE QUERY + PLAN>. Identify the bottleneck, suggest indexes or rewrites, and explain the trade-offs. Don't change the result set.
SQLFree
Vector search / RAG in 26ai
Show how to build AI Vector Search in Oracle 26ai over table <TABLE> column <TEXT_COL>: the VECTOR column, how to embed/populate it, and a similarity query for a user question. Include the SQL.
DevOpsFree
Dockerize an APEX/ORDS stack
Write a docker-compose.yml for Oracle 26ai Free + ORDS + APEX with a persistent volume, env-based password, and ports for the listener (1521), ORDS (8080) and EM Express (5500). Explain each service.
APEXFree
Build an APEX REST data source
Help me create an APEX REST Data Source for this API <PASTE OPENAPI / SAMPLE JSON>. Define the data profile (columns + types), pagination, and how to use it in an Interactive Report.
DocsFree
Auto-document a schema
Given these CREATE statements <PASTE>, produce developer docs: a table-by-table description, key relationships, and an ER summary in Mermaid. Keep it concise.