Maxwbh

Oracle APEX 24.2 focuses on development and a metadata dictionary, activatable across Dynamic Actions, Interactive Report, Interactive Grid, Classic Report, Page Process, AJAX Callback, Validations, Authorization Schemes, pagination, LOV, APEX_APPLICATION_*, APEX_APPLICATION_PAGE_*, APEX_WORKSPACE_*, APEX_APPL_*, Workflows, Tasks, AI configs, ACL, JSON Sources, and APEX_ACTIVITY_LOG.

Operational Oracle 19c DBA proficient in data dictionary (V$, GV$, DBA_*, CDB_*, DBA_HIST_*). Manages locked sessions, blocks, RAC, flashback, recompiles invalid objects, tablespaces, disk space, DBMS_STATS, AWR, ASH, Diagnostics Pack, Data Guard, and CDB/PDB.

Assistant for Oracle AI Database 26ai EE (version 23.26.x), focused on three new features. Activate it using terms like 26ai/23ai.

Oracle ORDS provides RESTful services and access to USER_ORDS_*/DBA_ORDS_* dictionary views. It covers module, template, handler activation, AutoREST, security with OAuth, JWT, PAR, privileges, and roles, alongside API versioning and CORS, noting the OAUTH package deprecation.

Oracle 19c performance tuning, utilizing explain plan, real-time AWR, ASH, indexes, hints, bind variables, and cursor sharing. Addresses slow queries, unwanted full scans, high hard parsing, poor execution plans, and outdated statistics.

Git and CI/CD structure for Oracle/APEX/ORDS projects, covering database object versioning, deployment scripts, GitHub Actions, APEX export via SQLcl, ORDS versioning, branch strategy, and rollback.

Trivadis PL/SQL Guidelines 4.4 — naming, code structure, and review. Activate for reviewing Oracle code against Trivadis standards, validating prefixes and naming conventions. Do not activate for code generation.

PL/SQL Oracle 19c: Experience with packages, procedures, functions, types, cursors, LOBs, and EBR. Proficient in BULK COLLECT, FORALL, NOCOPY, EXECUTE IMMEDIATE, MERGE INTO, compound triggers, editioning views, cross-edition triggers, CLOB/BLOB, Logger, exception handlers, and DML alternatives.