O'Reilly logo

Oracle Application Express 3.2 by Matthew Lyon, Arie Geller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Supporting Objects

When deploying an application we may often need to create or modify data, tables, stored procedures, and other database objects necessary for our application to run correctly. One way to deploy database changes is through SQL script files. In the SQL script files we enter DML and DDL statements for all required database changes. These scripts can then be run against the destination database schema to make the required changes. The SQL script files are separate to our application and means that there is an additional step on top of deploying the application source.

Supporting Objects is a function in APEX that can be used to create a single file for deployment. This file includes the application source together with any database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required