Understanding Oracle APEX 20 Application Development

This book shows developers and Oracle professionals how to build practical, non-trivial web applications using Oracle's rapid application development environment - Application Express (APEX). This third edition is revised to cover the new features and user interface experience found in APEX 20. Interactive grids and form regions are two of the newer aspects of APEX covered in this edition. The book is targeted at those who are new to APEX and just beginning to develop real projects for deployment, as well as those who are familiar with APEX and want a deeper understanding. The book takes you through the development of a demo web application that illustrates the concepts all APEX programmers should know. This book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. Topics include conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and security control. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 20 Application Development, 3rd Edition is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications. You will:

• Build attractive, highly functional web apps from the ground up
• Enhance and customize pages created by the APEX wizards
• Understand the security implications of page design
• Write PL/SQL code for process activity and verification
• Build complex components such as forms and interactive grids

Auteur
Edward Sciore is a recently retired Associate Professor in the computer science department at Boston College. He has been teaching college students for more than 35 years. His research specialty is database systems, and he thoroughly enjoys teaching the wonders of database technology to captive students.

Contenu

1. The SQL Workshop

2. Applications and Pages

3. Regions

4. Navigation

5. Items and Buttons

6. Session State

7. Processes

8. Data Validation

9. Branches

10. Forms

11. Interactive Grids

12. Dynamic SQL

13. Security