Oracle APEX Cookbook（Second Edition）

Creating swipe events>

Using jQuery Mobile to fetch current GPS location>

Uploading images using the camera on the device>

Creating a date scroller with the Mobiscroll plug-in>

Creating a mobile calendar>

Using mobile item types>

Creating a mobile form>

Creating a list view report>

Creating a hybrid application>

Creating a smartphone application>

Introduction>

Chapter 14. Mobile

Creating HTML5 charts>

Creating a video plug-in>

Geolocation – creating a tracker>

Creating storage events>

Creating a UI with drag-and-drop>

Creating a form with HTML5 item types>

Using a responsive HTML5 and CSS3 template>

Introduction>

Chapter 13. HTML5 and CSS3

Using follow-ups>

Using Feedback>

Creating Milestones>

Keeping track of bugs in the Bugtracker>

Creating and assigning To-dos>

Creating a list of features>

Introduction>

Chapter 12. Team Development

Creating table APIs>

Locking a workspace>

Creating a public theme>

Creating a site-specific task list>

Setting up news items on the home page>

Setting up a workspace announcement>

Setting up a system message>

Adding a schema to your workspace>

Creating a user>

Creating a workspace by request>

Creating a workspace manually>

Introduction>

Chapter 11. APEX Administration

Using packaged applications>

Creating an error handling>

Setting up the APEX Listener on Tomcat>

Setting up a production environment using an Apache proxy>

Setting up version control with APEX and SVN>

Deploying an application with SQL Developer>

Debugging an APEX application remotely>

Debugging an APEX application>

Setting up a development environment using subscriptions>

Introduction>

Chapter 10. APEX Environment

Calling a report from a page>

Linking the report layout to the report query>

Creating a report layout using Oracle BI Publisher>

Creating a report query>

Creating a PDF report>

Exporting to a comma-separated file>

Introduction>

Chapter 9. Publishing from APEX

Publishing a RESTful web service>

Building a page on a web service reference>

Creating a REST web service reference>

Creating a SOAP web service reference>

Introduction>

Chapter 8. Using Web Services

Creating a background process with apex_plsql_job>

Setting default item settings with apex_ui_default_update>

Counting clicks with apex_util.count_click>

Creating help functionality with apex_application.help>

Reading a checkbox programmatically>

Updating a table with the hidden primary key>

Introduction>

Chapter 7. APEX APIs

Translating data in an application>

Switching languages>

Using XLIFF files>

Creating a translatable application>

Introduction>

Chapter 6. Creating Multilingual APEX Applications

Creating an authorization plug-in>

Creating a process type plug-in>

Creating a dynamic action plug-in>

Creating a region type plug-in>

Creating an item type plug-in>

Introduction>

Chapter 5. APEX Plug-ins

Creating an enhanced datagrid from a spreadsheet>

Allowing multiple users access to a websheet>

Implementing a datagrid>

Adding a navigation section to a page>

Creating a page in a websheet>

Creating a websheet application>

Introduction>

Chapter 4. Creating Websheet Applications

Using shipped files>

Creating a data upload page>

Calling APEX from an Oracle Form>

Uploading and downloading files>

Sending mail via APEX>

Creating a region selector>

Embedding multimedia objects in your application>

Including Google Maps>

Enhancing your application with the Google API>

Creating visual effects with JavaScript libraries>

Creating a tag cloud with AJAX>

Adding JavaScript code to your application>

Introduction>

Chapter 3. Extending APEX

Controlling the layout>

Referencing CSS classes in your application>

Including images in your application>

Creating a custom template>

Importing a theme>

Creating your own theme>

Introduction>

Chapter 2. Themes and Templates

Creating a report with PL/SQL Dynamic Content>

Putting some validation in a form>

Creating an automated row fetch with a page process>

Creating a computation>

Controlling the display of regions and items with Dynamic Actions>

Securing an application with Authentication>

Protecting a page using an authorization scheme>

Including different item types>

Creating a list of values>

Creating a navigation bar>

Creating a map chart>

Creating a chart>

Implementing an interactive report>

Creating a simple report>

Creating a simple form page>

Creating an APEX 4.0 application>

Introduction>

Chapter 1. Creating a Basic APEX Application

Preface

www.PacktPub.com

About the Reviewers

About the Authors

Credits

版权信息

封面

封面

版权信息

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Chapter 1. Creating a Basic APEX Application

Introduction>

Creating an APEX 4.0 application>

Creating a simple form page>

Creating a simple report>

Implementing an interactive report>

Creating a chart>

Creating a map chart>

Creating a navigation bar>

Creating a list of values>

Including different item types>

Protecting a page using an authorization scheme>

Securing an application with Authentication>

Controlling the display of regions and items with Dynamic Actions>

Creating a computation>

Creating an automated row fetch with a page process>

Putting some validation in a form>

Creating a report with PL/SQL Dynamic Content>

Chapter 2. Themes and Templates

Introduction>

Creating your own theme>

Importing a theme>

Creating a custom template>

Including images in your application>

Referencing CSS classes in your application>

Controlling the layout>

Chapter 3. Extending APEX

Introduction>

Adding JavaScript code to your application>

Creating a tag cloud with AJAX>

Creating visual effects with JavaScript libraries>

Enhancing your application with the Google API>

Including Google Maps>

Embedding multimedia objects in your application>

Creating a region selector>

Sending mail via APEX>

Uploading and downloading files>

Calling APEX from an Oracle Form>

Creating a data upload page>

Using shipped files>

Chapter 4. Creating Websheet Applications

Introduction>

Creating a websheet application>

Creating a page in a websheet>

Adding a navigation section to a page>

Implementing a datagrid>

Allowing multiple users access to a websheet>

Creating an enhanced datagrid from a spreadsheet>

Chapter 5. APEX Plug-ins

Introduction>

Creating an item type plug-in>

Creating a region type plug-in>

Creating a dynamic action plug-in>

Creating a process type plug-in>

Creating an authorization plug-in>

Chapter 6. Creating Multilingual APEX Applications

Introduction>

Creating a translatable application>

Using XLIFF files>

Switching languages>

Translating data in an application>

Chapter 7. APEX APIs

Introduction>

Updating a table with the hidden primary key>

Reading a checkbox programmatically>

Creating help functionality with apex_application.help>

Counting clicks with apex_util.count_click>

Setting default item settings with apex_ui_default_update>

Creating a background process with apex_plsql_job>

Chapter 8. Using Web Services

Introduction>

Creating a SOAP web service reference>

Creating a REST web service reference>

Building a page on a web service reference>

Publishing a RESTful web service>

Chapter 9. Publishing from APEX

Introduction>

Exporting to a comma-separated file>

Creating a PDF report>

Creating a report query>

Creating a report layout using Oracle BI Publisher>

Linking the report layout to the report query>

Calling a report from a page>

Chapter 10. APEX Environment

Introduction>

Setting up a development environment using subscriptions>

Debugging an APEX application>

Debugging an APEX application remotely>

Deploying an application with SQL Developer>

Setting up version control with APEX and SVN>

Setting up a production environment using an Apache proxy>

Setting up the APEX Listener on Tomcat>

Creating an error handling>

Using packaged applications>

Chapter 11. APEX Administration

Introduction>

Creating a workspace manually>

Creating a workspace by request>

Creating a user>

Adding a schema to your workspace>

Setting up a system message>

Setting up a workspace announcement>

Setting up news items on the home page>

Creating a site-specific task list>

Creating a public theme>

Locking a workspace>

Creating table APIs>

Chapter 12. Team Development

Introduction>

Creating a list of features>

Creating and assigning To-dos>

Keeping track of bugs in the Bugtracker>

Creating Milestones>

Using Feedback>

Using follow-ups>

Chapter 13. HTML5 and CSS3

Introduction>

Using a responsive HTML5 and CSS3 template>

Creating a form with HTML5 item types>

Creating a UI with drag-and-drop>

Creating storage events>

Geolocation – creating a tracker>

Creating a video plug-in>

Creating HTML5 charts>

Chapter 14. Mobile

Introduction>

Creating a smartphone application>

Creating a hybrid application>

Creating a list view report>

Creating a mobile form>

Using mobile item types>

Creating a mobile calendar>

Creating a date scroller with the Mobiscroll plug-in>

Uploading images using the camera on the device>

Using jQuery Mobile to fetch current GPS location>

Creating swipe events>