Coffe Break

09:40 Coffee Break

Relax with a good coffee and get some energy for the next sessions.

Agenda

10:05 Source Code Management and Deployment Made Easy

Do you have a working approach to move your Oracle code changes (PL/SQL, APEX, ORDS) from your development environment to test and production? Or are you unhappy with your existing one, get errors during installation, miss changes that were not deployed or don't even know when you deployed the changes into which environment? The presented solution is an open source project (https://github.com/daust/opal-tools) and is based on 23 years of experience in developing software with Oracle PL/SQL, APEX and ORDS. In practice, a fully automated approach (e.g. Liquibase, Flyway, DB Maestro or Flexagon Flexdeploy) is costly and complicated. A partially automated support with a solid process model is sufficient in most cases. The exporter uses SQLcl together with DBMS_METADATA to export Oracle database objects, APEX applications, ORDS REST modules and everything as files into the filesystem in a very flexible and parameterized fashion. The installer uses SQLcl under the hood to actually run the SQL scripts. The core engine is very simple. It will execute SQL files which it finds by iterating through the filesystem and listing all files that exist. Log files and entries in log tables are automatically generated as needed. It provides a proven process model, but can be adapted very flexibly. It has been successfully deployed in multiple customer projects since Oct 2019. The developers using it are enthusiastic. We will explore different use cases and workflows how to manage your sources and quickly and easily distribute your code changes to other environments.

Dietmar Aust (OPAL Consulting)
Agenda
Lunch Break

12:25 Lunch Break

One hour lunch to get some food and clear your head.

Agenda
Coffe Break

16:05 Coffee Break

Relax with a good coffee and get some energy for the next sessions.

Agenda
After Conference Party

19:00 Dinner and Party

Dinner and Party with all your old and new APEX Friends. Glad to have you !

Location: Cocktailbar Niagara which is located right next to Hotel City (cross the parking lot underneath the bridge and you are there)

After Conference