Beginning Oracle Application Express 4.2, 2nd Edition

Beginning Oracle Application Express 4.2 introduces version 4.2 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4.2 brings extensive new Flash and HTML 5 charting capabilities, enhanced themes for mobile applications usable from phones and tablets, RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface.

Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX, Beginning Oracle Application Express 4.2 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company.

• Covers brand-new functionality in APEX 4.2
• Provides fully documented and explained example code
• Guides you through creating a working and fully deployable application

What you’ll learn

• Design, code, and troubleshoot APEX applications
• Create forms and generate reports
• Create charts using Flash and HTML 5
• Apply best-practices to database and application design
• Create intuitive navigation that inspires confidence among users
• Secure your applications from outside attack
• Deploy applications for one, a dozen, or hundreds of users
• Choose between desktop and mobile user interfaces for deployed applications

Who this book is for

Beginning Oracle Application Express 4.2 is for programmers and power users wanting to create rich, data-centric applications that are web-based, and that rest on Oracle’s industry-leading database technology.

Table of Contents

Chapter 1. An Introduction to APEX 4.2
Chapter 2. A Developer’s Overview
Chapter 3. Identifying the Problem and Designing the Solution
Chapter 4. SQL Workshop
Chapter 5. Applications and Navigation
Chapter 6. Forms and Reports—The Basics
Chapter 7. Forms and Reports—Advanced
Chapter 8. Programmatic Elements
Chapter 9. Security
Chapter 10. Application Bundling and Deployment
Chapter 11. Understanding Websheets
Chapter 12. A Websheet Example
Chapter 13. Extended Developer Tools
Chapter 14. Managing Workspaces
Chapter 15. Team Development
Chapter 16. Dynamic Actions