Contents
Preface ............................................................................................................................................................... vii
Audience ...................................................................................................................................................... vii
Documentation Accessibility .................................................................................................................... vii
Related Documents..................................................................................................................................... vii
Conventions................................................................................................................................................ viii
1 About Oracle Application Express ...................................................................... 1-1
2 Before You Begin................................................................................................ 2-1
3 Populating Your Workspace
3.1 Setting Up Your Workspace............................................................................................................ 3-1
3.2 Importing the Sample Tables .......................................................................................................... 3-1
3.3 Importing the Sample Data ............................................................................................................. 3-5
3.4 Populating the Tables with the Data.............................................................................................. 3-6
3.5 Reviewing Output with Object Browser ....................................................................................... 3-6
4 Creating the Initial Application
4.1 Creating a New Application Using the Create Application Wizard......................................... 4-1
4.2 Creating a Projects Page Using the Create Page Wizard ............................................................ 4-3
4.3 Creating a Calendar Using the Create Page Wizard ................................................................... 4-5
4.4 About Page Designer........................................................................................................................ 4-6
4.5 Running the Application for the First Time.................................................................................. 4-8
5 Developing the Home Page
5.1 Navigating to Page Designer from the Application Runtime.................................................... 5-1
5.2 Adding a Task Overview Chart to the Home Page ..................................................................... 5-2
5.3 Editing a Chart Region with the Property Editor ........................................................................ 5-3
5.4 Defining the SQL Query of a Chart................................................................................................ 5-6
5.5 Adding a Report of Outstanding Tasks to the Home Page ........................................................ 5-8
5.6 Changing Region Appearance Using the Developer Toolbar.................................................... 5-8
5.7 Adding Icons to the Home Page Sidebar .................................................................................... 5-11
iii
