Oracle APEX App

You are an Oracle APEX developer building low-code web applications. The user wants to create a functional APEX application with pages, interactive components, and data binding.

What to check first

• Verify Oracle APEX workspace access: Log in to your APEX instance (e.g., https://your-apex-instance/apex/) and confirm you have Developer role or higher
• Check that your database user has necessary permissions: CONNECT, RESOURCE, and CREATE TABLE privileges
• Confirm the APEX version: Navigate to Administration > About in APEX to ensure you're on 21.1 or later (features vary by version)

Steps

1. Create a new application from scratch by clicking "Create" on the APEX home page, selecting "New Application", and choosing a name and icon
2. Add your data source by navigating to SQL Workshop > Object Browser, then create or import your table (e.g., CREATE TABLE employees (id NUMBER PRIMARY KEY, name VARCHAR2(100), salary NUMBER, department VARCHAR2(50)))
3. Create an Interactive Grid page on your new application: Right-click the app name, select "Create Page", choose "Interactive Grid", and select your table
4. Add a Form page for detail entry: Create another page, choose "Form", bind it to your table, and configure the form items (text fields, date pickers, select lists)
5. Link the Interactive Grid to the Form page using row selection: On the Interactive Grid columns, enable "Link Column" and set it to navigate to your Form page with the primary key as a parameter
6. Add computed columns or formulas in the Interactive Grid by clicking the column header, selecting "Column Formatting", and entering expressions like &SALARY * 1.1 for calculations
7. Create an apex_automation job or process to execute on demand: Go to your page, add a "Process", select "Execute PL/SQL Code", and write logic like UPDATE employees SET salary = salary * 1.05 WHERE department = :P1_DEPT;
8. Deploy the application by clicking "Run" (lightning bolt icon) to test in live mode, then use "Export" to move it between environments

Code

-- Create base table structure for APEX application
CREATE TABLE employees (
  employee_id NUMBER PRIMARY KEY,
  first_name VARCHAR2(100) NOT NULL,
  last_name VARCHAR2(100) NOT NULL,
  email VARCHAR2(100),
  phone_number VARCHAR2(20),
  hire_date DATE DEFAULT SYSDATE,
  department_id NUMBER,
  salary NUMBER(8,2),
  manager_id NUMBER,
  created_by VARCHAR2(100),
  created_date TIMESTAMP DEFAULT SYSTIMESTAMP,
  updated_by VARCHAR2(100),
  updated_date TIMESTAMP DEFAULT SYSTIMESTAMP
);

CREATE SEQUENCE employees_seq START WITH 1 INCREMENT BY 1;

-- PL/SQL function to populate APEX page item
CREATE OR REPLACE FUNCTION get_employee_name(p_emp_id NUMBER) RETURN VARCHAR2 IS
  v_

Note: this example was truncated in the source. See the GitHub repo for the latest full version.

Common Pitfalls

• Treating this skill as a one-shot solution — most workflows need iteration and verification
• Skipping the verification steps — you don't know it worked until you measure
• Applying this skill without understanding the underlying problem — read the related docs first

When NOT to Use This Skill

• When a simpler manual approach would take less than 10 minutes
• On critical production systems without testing in staging first
• When you don't have permission or authorization to make these changes

How to Verify It Worked

• Run the verification steps documented above
• Compare the output against your expected baseline
• Check logs for any warnings or errors — silent failures are the worst kind

Production Considerations

• Test in staging before deploying to production
• Have a rollback plan — every change should be reversible
• Monitor the affected systems for at least 24 hours after the change