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.

What You Will Learn

• 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
  Who This Book Is For
  Developers new to APEXwho desire a strong fundamental understanding of how APEX applications work. For existing developers and database administrators desiring to mine the most value from APEX by improving their development techniques.

Teaches you how to develop non-trivial APEX applications Provides a deep understanding of APEX functionality Shows the techniques needed for customization

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. <p