Create an Application from a File
Start course

This course will guide you through how to create a database application through a variety of features offered by Oracle APEX.

Learning Objectives

  • Gain a foundational understanding of App Builder Concepts
  • Learn how to access App Builder and how to access the Create Application Wizard to build your APEX applications.
  • Understand how to create an APEX application based on existing tables
  • Understand how to create an Apex application from a file
  • Learn about Progressive Web Applications and how to enable Progressive Web Application installability within your APEX application

Intended Audience

  • Anyone who wants to enhance their knowledge of Oracle APEX


We recommend that you take this course as part of our Oracle APEX: Foundations learning path.


Hello. Welcome to Oracle Apex Foundation course, Creating A Database Application Module: creating an application from a file lesson. My name is Chaitanya, I am a product manager on the Oracle Apex Product Development team. So, you only learn how to create an APEX application based on existing database tables. Now let's learn how to create an application from a file. In this lesson, we learn how to create an Apex application from a file. We learn how to convert a spreadsheet into your beautiful, responsive, secure, and scalable web application using Oracle Apex. Creating an Apex Application from a file. To create an Apex application from a file, navigate to your workspace homepage and then click 'App Builder.' Click 'Create,' and then select from a file. Now, let's watch a quick demo that showcases how to upload a spreadsheet and convert that into an Apex Application. The spreadsheet that you use in this demo contains projects and associated tasks data such as project name, task name, start date in deep, status assigned to cost and budget. Once you upload this spreadsheet data, Apex creates an underlying database table, on top of which will be creating an Apex Application. Creating an Apex Application from a file. On your workspace homepage, click 'App Builder,' and then click 'Create.' Select from a file. The load databases appears with the Upload File tab selector. That you have other option copy and paste. You select 'Upload a File,' if you want to load data from a CSV, XLSX, XML, text, or JSON file. You click 'Copy and Paste' if you want to copy and paste column delimited data. Now clicking this option, you also see that you can select a sample data set from the Select Sample list. Now in our example, we want to upload a file and then create an Apex Application. Notice that you can drag and drop file here or click 'Choose File' to select and upload your file from your folder. Now let's click 'Choose File,' and select Project_Tasks.csv file, and then upload the file. On the Load Data page, under where do you want to load this data to see Load To New Table or Existing Table. It is example, Lets accept the default New Table. You also see Table Owner, and then for Table Name, let's enter a name, for example TASKS. Notice that the table names are by default converted into uppercase. Now for primary keys, we have two options; either you can include SYS_GUID or select 'Identity Column.' Lets accept the default for primary keys as well and then scroll down a little bit. We now see, please select the columns to load. So, let's click 'Configure.' In the Configure dialogue, notice the column names on the column types. You can also preview. We haven't made any changes, so lets close this dialogue. Now, under Settings, notice that the first line contains headers checkbox, under Column Headers is selected. We can also choose to have a Column Delimiter, Enclosed By, and File encoding settings. You can preview the data and finally click 'Load Data.' Notice that the table tasks is created with 73 rows. You can now click 'View Table' to view this particular table in SQL Workshop. Alternatively, you can click 'Create Application' button that navigates you to the Create Application wizard. Let's click the 'Create Application' button. In the Create Application wizard, enter a name for the application. Let's enter Tasks App. And then for appearance, let's click 'Set Appearance' icon, and then select 'Redwood Light' Theme Style. Access the default for navigation and then let's click 'Save Changes.' Now, if you scroll down,, you can see homepage, Dashboard Page, Tasks Search Page, Tasks Report, and Calendar have been added by default to the application. Scroll down a bit. You can see features. So, you can select a checkbox for any of these features, and if you want to select all of these features click 'Check All.' So, lets click 'Check All.' Review the settings and then click 'Create application.' Can now see the application creation progress. The application is now successfully created, so lets click a 'Run Application.' Enter your workspace username and password, and then click 'Sign In'. Tasks Application homepage is displayed for you. You can now see Dashboard, Task Search Page, Tasks Report, and Calendar. Let's click the left navigation menu, and you can see whole Dashboard, Task Search, Tasks Report, Calendar, and Administration listed over here. Lets click 'Dashboard.' Review the charts in the dashboard. We can see charts display for Project, Task Name, Status and Assigned To. Let's click 'Tasks Search.' This is a fasted search page, and the list click 'Tasks Report,' which is an interactive report page, and then let's click 'Calendar,' which is a calendar that displays the project details for you. So, you now understand how to upload a spreadsheet and quickly convert that into an fully functional Apex Application that can be extended further. In this lesson, we learn how to create an Apex Application from a file. This concludes the lesson on creating an application from a file. I am sure you're amazed at how we went from spreadsheet data to your fully functional Apex Application in just minutes. Thank you for watching.

About the Author
Oracle University
Training Provider
Learning Paths

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.

Covered Topics