SQLcl has a great feature to easily export an APEX application.
> sqlcl giffy/[email protected]:32122/orclpdb1810.localdomain
This will produce a file in the current directory called
I was recently asked how to export an application using SQLcl and set the
Build Status Override option. This is available when manually exporting the application as shown below. This option is usually set to
Run Application Only in production environments to prevent others from modifying the application.
There is no option (that I know of) to set the
Build Status Override option when doing an SQLcl export. After doing a diff between manual exports with the different settings for
Build Status Override the only change is the parameter
If you want to create an application export for a run only environment (i.e. production) just run the following bash commands after the export:
This will produce two files:
> ls -1 f*.sql