Creating an APEX Application
from spreadsheet
Logon to Oracle APEX Workspace
Document created by [Link]
Click on Application Builder
Document created by [Link]
Click on ‘Create’ icon
Document created by [Link]
Select ‘Create from spreadsheet’. Click
‘Next’
Document created by [Link]
Select ‘Copy and paste’. Click ‘Next’
Document created by [Link]
Copy the data from spreadsheet and
paste in the window
Document created by [Link]
Select and copy the data from
spreadsheet
Copy the data from spreadsheet
Document created by [Link]
Paste the copied data in APEX. Click
‘Next’
Document created by [Link]
APEX will analyze the pasted data and will come
up with table structure. You can edit it, if required
Specify the table
name
The datatype will
be selected
automatically
Say ‘No’ to
columns you
don’t want to
upload
Document created by [Link]
Enter a singular name and plural name.
Edit the labels
Singular name and
plural name will be
used in the application
These labels will
become column
headings in report and
field labels in forms
Document created by [Link]
Select the column for which data
should be summarized in reports and
charts.
For this application we want
to summarize the data on
participant’s country. Click
on ‘COUNTRY’
Document created by [Link]
Enter the ‘Application Name’ and click
‘Next’.
Document created by [Link]
Select theme which will define the look and feel of
the application
Document created by [Link]
Click ‘Create’ to create the application
Document created by [Link]
Click ‘Run Application’ to see how
does the application look like.
Document created by [Link]
Enter workspace user name and password.
Click ‘Login’. Notice the user interface.
Look and feel coming from
theme selected while
creating the application
Document created by [Link]
And here is our application. Neatly built from a
spreadsheet, without writing even a single piece of code.
For Creating a
New Record
Plural Name used here
For Editing or Deleting
an existing Record
Document created by [Link]
You can edit the record as required. Notice ‘Cancel’,
‘Delete’, ‘Apply Changes’, & ‘Next’ buttons.
To go to
next record
Document created by [Link]
‘Create’ a new record screen.
Singular Name used here
Plural Name used here
You can add a new record and
click on ‘Create’ button to save
the record. Click ‘cancel’ to
discard your changes.
Document created by [Link]
From main page click on ‘Analyze’ tab
Analyze
tab
Document created by [Link]
Click ‘By Country’ under ‘Reports’ or
‘Charts’
Clicking on ‘By Country’ on ‘Reports’ will
display a country wise report. Click under
the ‘Charts’ will display the data in a pie-
chart. All this without writing any single
code
Document created by [Link]
Click on ‘Home’ link to get back to APEX
workspace home page
Document created by [Link]
Back to Workspace
Document created by [Link]
DBCON presents Live Online Training in Oracle
Application Express. The best and most convenient
way to learn Oracle Application Express.
Check out today at [Link]
Or E-Mail
contact@[Link]
For more tutorials on Oracle Application Express
checkout our blog at
[Link]
Document created by [Link]