Simpli Learn: Creating and Copying an Application in APEX by using various options

Create an Application in APEX

An application can be created from the "Create" Application Wizard once you login to the APEX workspace

Common use cases when using the Create Application Wizard include:

Create an app from existing data. Create an application and set of initial pages based on existing data from a table or a query. Then, select application features, specify a theme, and configure options
Create an app and add pages. Create an application and then add pages one at a time using the Create Page Wizard
Create an app from a file. Create an application from a file by uploading a CSV, XLSX, XML, or JSON file, or by copying and pasting data directly into the wizard
Create an app based on a script. Create an application containing many pages from a saved script in SQL Scripts
Create an app based on a dataset. After you install a sample data set, you have the option to create an application containing multiple pages on that dataset

Once you click on the Create Application Wizard, you will see the following screen

Enter the Name

Under the Appearance, you will see the following options

Under the Theme Style

You can either choose Vita or Vita-Dark or Redwood Light

In the Navigation

You can have either Side Menu or Top Menu or Mega Menu depending on your requirement

Once done, click on save Changes. You will be back to Create Application Wizard page

By Default Home page and few other pages will be added. If you want to add more pages you can click on Add Page under Pages section

Then comes the Features section. The following options you will have to choose

Once done Click on Create Application button, it will spin up the App for you within the workspace you have requested and logged in.

You will see the following screen

There are two options in which either you can opt to Upload a File or Copy and Paste. The Copy and Paste looks as below

In this case I have decided to upload a csv format. Once you upload, it takes you to the next page with the following options

Load to: New Table or Existing Table

Table Owner:

Table Name:

Primary Keys:

You can Preview the data that being parsed and make necessary changes

Once done, click on Load Data to create an Application

You will see the following screen, where you can choose an app that needs to install

Once you click on the Install button on any app, a pop window comes up to confirm the apps installation

In this case, I selected APEX PWA Reference App

Once done, click on Install Application button to install the app

To copy application by running the Create Application Wizard:

On the Workspace home page, click the App Builder icon
Click the Create button. The Create Application Wizard appears
Select the Copy Application link at the bottom of the window and click Next
For Identify Copy Target:

Copy From - Select the name of the application to copy
Copy To - Enter a short descriptive name for the application to distinguish the new application in select lists and reports
New Application ID - Specify an integer value that identifies the application. The application ID must be unique within your Oracle APEX instance. Application IDs in the range of 3000 to 9000 are reserved for internal use by APEX
Copy Supporting Object Definitions - You can copy supporting object definitions, configuration options, and scripts with your application. Select On to include database object definitions, image definitions, and seed data SQL statements encapsulated in a single file. Select Off to not include supporting object definitions.