AI agents are changing the way software is developed, making it possible to perform complete development tasks rather than simply generate code snippets. For Oracle teams, the practical question is how to start working this way with Oracle Database and APEX, and how to gradually and systematically integrate this approach into the existing development process.

Through a realistic development scenario, we will see how an agent works with a database schema and APEX applications, understands the context, makes changes, tests the results, and improves the solution under the developer’s guidance.

The demonstrations will include working with Oracle Database using SQLcl MCP, developing and testing SQL and PL/SQL and using APEXlang to build and modify APEX applications and pages. We will see how agents can also assist in identifying and resolving issues, as well as with tasks that concern many development teams, including migrating from Oracle Forms to APEX and upgrading and modernizing existing APEX applications.

Throughout the lecture, we will also examine how to start working with agents effectively: what context needs to be provided to them, which tasks are appropriate to delegate, how to define permissions and operational boundaries and how to validate the code and results throughout the development process. This can reduce manual work and accelerate development while keeping developers in control of the architecture, security and quality of the solution.

The lecture is intended for Oracle APEX developers, SQL and PL/SQL developers, architects and technical leads who want to understand how to practically integrate AI agents into their development work.

No significant prior experience working with AI agents is required. Basic familiarity with Oracle Database, SQL, PL/SQL, and APEX is recommended.

Key topics include:

• Performing end-to-end development tasks using AI agents with Oracle Database and APEX.
• Working with Oracle Database using SQLcl MCP, including understanding the schema, creating and modifying objects and developing and testing SQL and PL/SQL.
• Using APEXlang to build and modify APEX applications and pages.
• Using AI agents to identify and resolve issues and to modernize existing systems, including migrating from Oracle Forms to APEX and upgrading existing APEX applications.
• Building an efficient and controlled workflow with AI agents, including providing context, defining permissions and operational boundaries, and validating code and results throughout the development process.