Book description
Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out Oracle in years. Application Express, termed APEX for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users.
Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle's new plug-in architecture. You'll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the "hard problems" are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer.
Focuses on high-end, enterprise-level development
Covers new features such as plug-ins and Websheets
Introduces the new interface released with APEX 4.0
What you'll learn
Design APEX solutions that conform to your corporate look-and-feel
Create compelling reports, charts, navigation, and layout
Create your own components based upon APEX's new plug-in architecture
Authenticate users and manage their access to your applications
Develop and deploy web services using APEX
Scale APEX applications to thousands of users
Secure your applications and data from intrusion
Who this book is for
Pro Oracle Application Express 4 is aimed at application developers looking for a rapid application development environment harnessing the full power of the Oracle Database, including SQL and PL/SQL. The book meets the needs of developers working at both the departmental and the enterprise level, with an emphasis on high-end, enterprise deployment.
Table of contents
- Copyright
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Foreword
- Introduction
-
1. Development Best Practices
- 1.1. APEX Installation Decisions
- 1.2. Application Development Considerations
- 1.3. Performance Considerations
- 1.4. Team Development
- 1.5. New Development Features in APEX 4.0
- 1.6. Summary
-
2. Authentication and User Management
- 2.1. Preconfigured Authentication Schemes
- 2.2. Open Door Credentials
- 2.3. No Authentication
- 2.4. Application Express Account Credentials
- 2.5. Database Account Authentication
- 2.6. Custom Authentication
- 2.7. Implementing Locked User Accounts
- 2.8. Automating User Registration
- 2.9. Managing Session Timeouts
- 2.10. Summary
-
3. Conditions and Authorization Schemes
-
3.1. Specifying Condition Types
- 3.1.1. No Condition
- 3.1.2. Exists (SQL Query Returns at Least One Row)
- 3.1.3. NOT Exists (SQL Query Returns No Rows)
- 3.1.4. SQL Expression
- 3.1.5. PL/SQL Expression
- 3.1.6. PL/SQL Function Body Returning a Boolean
- 3.1.7. Request = Expression 1
- 3.1.8. Request != Expression 1
- 3.1.9. Request Is Contained Within Expression 1
- 3.1.10. Value of Item in Expression 1 = Expression 2
- 3.1.11. Value of Item in Expression 1 Is NULL
- 3.1.12. Current Page = Expression 1
- 3.1.13. Current Page Is Contained Within Expression 1 (Comma Delimited List of Pages)
- 3.1.14. User Is Authenticated (Not Public)
- 3.1.15. User Is the Public User (User Has Not Authenticated)
- 3.1.16. Current Language Is Contained Within Expression 1
- 3.1.17. Never
- 3.2. Using Conditions Appropriately
- 3.3. Authorization Schemes
- 3.4. Summary
-
3.1. Specifying Condition Types
- 4. Data Security
- 5. Navigation and Layout
- 6. Reports and Charts
- 7. Dynamic Actions
- 8. Websheets
-
9. Reporting and Printing
- 9.1. Choosing a Print Server
- 9.2. Configuring APEX to Use a Print Server
- 9.3. Printing Reports
- 9.4. Creating Custom Report Layouts with BI Publisher
- 9.5. Generating Reports Through Apache FOP
- 9.6. Summary
-
10. Themes and Templates
- 10.1. Themes
-
10.2. Templates
- 10.2.1. Removing Unused Templates
- 10.2.2. Viewing Template Information
- 10.2.3. Understanding Template Types and Classes
- 10.2.4. Managing Template Files
- 10.2.5. Choosing a Template Type
- 10.3. Template Subscriptions
- 10.4. Tools for Working with Templates
- 10.5. Summary
-
11. Localization Issues
- 11.1. Localizing Application Builder
- 11.2. Localizing Your Applications
- 11.3. Fully Translating Your Applications
- 11.4. Summary
- 12. Plug-ins
- 13. Web Services
- 14. Performance and Scalability
-
15. Production Issues
- 15.1. Managing URLs
- 15.2. Backing Up Applications
- 15.3. Migrating Between Environments
- 15.4. Summary
- 16. APEX Dictionary
Product information
- Title: Pro Oracle Application Express 4, Second Edition
- Author(s):
- Release date: June 2011
- Publisher(s): Apress
- ISBN: 9781430234944
You might also like
book
Pro Oracle Application Express
Application Express, or APEX, is one of the most innovative products to come out of Oracle …
book
Beginning Oracle Application Express 4
Beginning Oracle Application Express 4 introduces one of the most talked about development platforms to come …
book
Beginning Oracle Application Express 4.2, Second Edition
Beginning Oracle Application Express 4.2 introduces version 4.2 of the popular and productive Oracle Application Express …
book
Oracle Application Express 4 Recipes
Oracle Application Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application …