Oracle APEX Cookbook : Second Edition

Get straight into developing modern web applications, including mobile, using the recipes in this brilliant cookbook for Oracle Application Express (APEX). From the basics to more advanced features, it’s a reference book and guide in one.

Oracle APEX Cookbook : Second Edition

Cookbook
Michel Van Zoest, Marcel Van Der Plas

Get straight into developing modern web applications, including mobile, using the recipes in this brilliant cookbook for Oracle Application Express (APEX). From the basics to more advanced features, it’s a reference book and guide in one.
$35.99
$59.99
RRP $35.99
RRP $59.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781782179672
Paperback444 pages

About This Book

  • Explore APEX to build applications with the latest techniques in AJAX and Javascript using features such as plugins and dynamic actions
  • With HTML5 and CSS3 support, make the most out of the possibilities that APEX has to offer
  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Who This Book Is For

This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand.

If you are new to APEX you will find recipes to start development and if you are an experienced user you will find ways to improve your productivity and efficiency and make the most of APEX to enhance your applications.

A little knowledge of PL/SQL, HTML and JavaScript is assumed.

Table of Contents

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

What You Will Learn

  • Produce feature-rich web applications in APEX 4.2
  • Create smartphone applications using jQuery Mobile
  • Use HTML5 and CSS3 in APEX
  • Generate RESTful web services
  • Working with the latest available plug-in types.
  • Make the development process easier by enhancing error handling
  • Developing HTML5 and CSS3 supported web applications
  • Follow hands-on examples to make the most out of the possibilities that APEX has to offer

In Detail

Oracle Application Express (APEX) is a powerful, productive tool that helps you create modern web applications. The goal is to make everything declarative so the developer can reduce the amount of coding. With the jQuery mobile templates included, it is now also possible to create web applications for mobile devices, supporting mobile specific functionalities such as touch events.

"Oracle APEX Cookbook : Second Edition" covers all the details of Application Express, giving you complete control over the new features. It shows you how to create web applications, while explaining you the concepts and bringing out useful tips and techniques to make learning interesting for you.

In this second edition, you will learn how to modify themes and templates and how to use the new HTML5 and CSS3 features. You will also learn how to create visual effects such as tool tips and fading options. Furthermore, topics such as web services, publishing, administration, team development, and web sheets will be covered.

This book will show you how to be agile in the development of your web applications by using team development, debugging, and third-party tools. After reading this book, you will be able to create feature-rich web applications in Application Express 4.2 with ease and confidence.

Authors

Table of Contents

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

Book Details

ISBN 139781782179672
Paperback444 pages
Read More