Book Image

Oracle APEX 4.0 Cookbook

By : Michel Van Zoest, Marcel Van Der Plas
Book Image

Oracle APEX 4.0 Cookbook

By: Michel Van Zoest, Marcel Van Der Plas

Overview of this book

<p>Oracle Application Express 4.0 is a rapid web application development tool that works with the Oracle database. Using features like Plug-ins and Dynamic Actions, APEX helps you build applications with the latest techniques in AJAX and JavaScript.</p> <p>The Oracle Application Express 4.0 Cookbook shows you recipes to develop and deploy reliable, modern web applications using only a web browser and limited programming experience. <br /><br />With recipes covering many different topics, it will show you how to use the many features of APEX 4.0.<br /><br />You will learn how to create simple form and report pages and how to enhance the look of your applications by using stylesheets. You will see how you can integrate things such as Tag Clouds, Google Maps, web services, and much more in your applications. Using Plug-ins, Dynamic Actions, BI Publisher, translations and Websheets, you will be able to enhance your applications to a new level in APEX.</p> <p>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.</p> <p>After reading this book, you will be able to create feature-rich web applications in Application Express 4.0 with ease and confidence.</p>

Related Content you might be interested in

Current Title:

Small book image
Oracle APEX 4.0 Cookbook
Michel Van Zoest | Marcel Van Der Plas
Dec, 2010 | 328 pages
No titles found
Table of Contents (19 chapters)
Oracle APEX 4.0 Cookbook
Oracle APEX 4.0 Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Creating a Basic APEX Application
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
Control 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
2
Themes and Templates
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
3
Extending APEX
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
4
Creating Websheet Applications
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
5
APEX Plug-ins
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
6
Creating Multilingual APEX Applications
Creating Multilingual APEX Applications
Introduction
Creating a translatable application
Using XLIFF files
Switching languages
Translating data in an application
7
APEX APIs
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
8
Using Webservices
Using Webservices
Introduction
Creating a SOAP webservice reference
Creating a REST webservice reference
Building a page on a webservice reference
9
Publishing from APEX
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
10
APEX Environment
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 Weblogic
11
APEX Administration
APEX Administration
Introduction
Creating a workspace manually
Creating a workspace by request
Creating a user
Adding a schema to your workspace
Setting a system message
Setting a workspace announcement
Setting news items on the home page
Creating a site-specific task list
Creating a public theme
Locking a workspace
12
Team Development
Team Development
Introduction
Creating a list of features
Creating and assigning To-do's
Keeping track of bugs in the Bugtracker
Creating Milestones
Using Feedback
Using Follow-ups
Index
Index

About the Authors

Marcel van der Plas has been an Oracle Consultant for over 15 years. And from the beginning, he learned to work with Oracle Forms, Oracle Reports, and Oracle Designer. Marcel has worked on many projects with these tools. Later on, he became interested in APEX and did some projects with APEX.

Marcel currently works for Ciber. Other companies he worked for are Atos Origin and Whitehorses. For Whitehorses, he wrote some articles ("Whitebooks") about Oracle.

I would like to thank Michel van Zoest, my co-author for helping and working together. I also want to thank the reviewers Maarten van Luijtelaar, Dimitri Gielis, and Surachart Opun. Their comments were so valuable and helpful. I would like to thank Douwe Pieter van den Bos for introducing us to Packt and I would like to thank Packt for giving me this opportunity to write this book. I would like to thank my employer, Ciber, for giving me the freedom to write this book.

Last but not least, I would like to thank my wife Yvonne and my children Vera, Laura, and Joey for inspiring and supporting me. At the same time, I would like to apologize to them for not having time to play on the weekends during the months that I wrote this book.

Michel van Zoest is a consultant with more than 10 years of experience in building (web) applications using Oracle technology such as Oracle (web) Forms, Oracle Designer, MOD_PLSQL, ADF, SOA Suite and of course, APEX.

He is one of the first Oracle Application Express Developer Certified Experts in the world.

He has used his APEX knowledge in projects for companies ranging in size from a single employee to large multinationals. His experience in these projects has been used in the realization of this book.

Michel currently works at Whitehorses in the Netherlands and runs his own blog at http://www.aboutapex.com. Next to that, he blogs at the company website on http://blog.whitehorses.nl and he regularly writes Whitebook articles (in Dutch) for Whitehorses.

First of all, I would like to thank my co-author Marcel van der Plas. Thanks to the easy way that we could work together, the writing of this book has gone as smooth as possible.

I would like to thank the people at Packt Publishing for offering me the chance to write this book. It has been a long process with a lot of hard work, but I'm very happy with the result. I also would like to thank Douwe Pieter van den Bos for introducing me and Marcel to Packt and his invaluable help in the early stages of the book.

Furthermore, I would like to thank Maarten van Luijtelaar, Dimitri Gielis, and Surachart Opun for their hard work in reviewing our drafts. This book has become so much better thanks to you guys.

I also would like to thank my employer Whitehorses for the support I have been given.

And last but not least, I would like to thank my family for their love and support. Without the help of my wife Jamila and the "dikke kroelen" from my daughters Naomi and Aniek, this result would not have been possible.

Previous Section
Next Chapter