6.1 About the Create Application Wizard

To create an Oracle Application Express application, a developer runs the Create Application Wizard.

To run the Create Application Wizard, click the Create button on the App Builder home page.


The first time you access the App Builder home page, grey box labeled Create a New App appears. Clicking Create New App is a shortcut to accessing the Create Application Wizard.

When you run the Create Application Wizard, the wizard prompts you to choose the type of application you want to create. Options include:

  • New Application. Create a fully functional database application based on tables you select or by providing a valid SQL. You can add pages that include various components including calendars, cards, charts, dashboards, forms, interactive grids, master detail or editable grids, and reports. Add application-level features such as an Application About page, role-based user authentication, end user activity reports, configuration options to enable or disable specific functionality, a feedback mechanism to gather end users comment, and a Customize button to enable end users to choose their own theme style

  • From a Spreadsheet. Load spreadsheet data from a spreadsheet by importing it from a file as comma separated (*.csv) or tab delimited file, or by copying and pasting tab delimited data. Once you approve a page preview, the wizard loads the data into the database, creates a report and form on the data, and then displays the Create Application Wizard to complete the application creation process.

  • Packaged App. Links to the Packaged Apps gallery. Packaged Apps include a set of business productivity and sample applications which can be installed with just a few clicks. Productivity apps are fully developed point-solutions designed to provide real functionality, such as project management, surveys, shared calendars, and tracking applications. Productivity applications can be installed, run and removed. By default they are 'locked' and are fully supported. Once unlocked, the application is no longer supported but it can be updated to meet specific requirements. Sample apps are not a complete applications but instead contains code snippets or sample code. Sample applications are available for installation in a workspace and are editable by default.

  • Websheet. Websheet applications enable users to build data centric applications without any SQL programming knowledge. Websheet applications are simplified applications that support pages, data grids, and reports. By creating These applications are very easy to build and are designed to support community contributions.

  • Quick SQL. Generate the SQL required to create a relational data model from an indented text document. Quick SQL is designed to reduce the time and effort required to create SQL tables, triggers, and index structures.

  • Copy Application. Create a copy of an existing application.