Tested prompts for Oracle work

You are an Oracle APEX 26.x 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.

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.

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.

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.

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.

Generate an Oracle package spec and body for these requirements: <REQUIREMENTS>. Include input validation, exception handling, and concise comments. Follow <NAMING CONVENTION>.

Write utPLSQL unit tests for this procedure: <PASTE>. Cover happy path, boundary values, null inputs, and the exceptions it raises.

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.

For each Forms object in this blueprint <PASTE>, propose the equivalent Oracle APEX 26.x component, note what has no direct equivalent, and rank migration risk (low/med/high) with mitigation.

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.

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.

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.

Write a docker-compose.yml for Oracle 26ai Free + ORDS + APEX with a persistent volume, env-based password, and ports for the listener (1521) and ORDS (8080, serving APEX and SQL Developer Web). Explain each service.

Explain what this legacy PL/SQL does in plain <English/Arabic>, list its inputs/outputs and dependencies, and note risks before modernizing: <PASTE>.

Given these CREATE statements <PASTE>, produce developer docs: a table-by-table description, key relationships, and an ER summary in Mermaid. Keep it concise.