Databases Reference
In-Depth Information
Figure 9-7.
Saving the exported SQL file
How It Works
An application in APEX consists of metadata, data, and business logic, and all of it sits nicely in the
Oracle database. When you export an application, it exports all the metadata into an SQL file. By running
this SQL file, it will rebuild the entire application from scratch on the target machine.
If you open the exported file in a text editor (such as Notepad), you will see that the content of the
file are mostly PL/SQL function calls and DML that specifies the schema of your database and
application objects. This is shown in Figure 9-8.
