3 Review(s)

Develop Native Oracle database-centric web applications quickly and easily with Oracle APEX Grasp the principles behind APEX to develop efficient and optimized data-centric native web applications, for the Oracle environment Gain a better understanding of the major principles and building blocks of APEX, like the IDE and its modules Review APEX-related technologies like HTML and the DOM, CSS, and JavaScript, which will help you to develop better, richer, and more efficient APEX applications Learn to Globalize APEX applications, including Right-To-Left support This book covers APEX version 3.2, but the information is broadly applicable to all 3.x versions In Detail Developing data-centric web applications can be a real challenge as it is a multi-disciplinary process. There are many technologies involved in the client side (HTML, CSS, JavaScript, and so on); the interaction with the database, on the server side; the typeless nature of the web environment; and above all, the need to put it all together. This needs to be done in a manner that will allow the end users to do their job in the simplest and most efficient way, while enriching their user experience. How often have you wished that developing such applications could be uncomplicated and straightforward? This book will show you that it's possible, and teaches you how to do it, using Oracle Application Express (APEX). With this practical guide to APEX, you'll learn how to easily develop data-centric web applications for the Oracle environment. The book covers the development cycle of an APEX application, reviewing the major APEX principles and building blocks chapter by chapter. It starts with the basic skills you need to get going when developing with APEX. Later, you will learn advanced issues, such as how to build tailor-made forms and reports, using APEX APIs, AJAX, and so on. It not only deals with the "How" but also with the "Why", and before long you will be able to understand APEX concepts, and use them to expand and enhance the built-in features, wizards, and tools. The book starts with the design phase, including building the necessary database objects infrastructure; continues with ways to implement the application logic (on the server side) and the User Interface (on the client side), whilst showing you how to enhance your applications' features and functionality according to your specific needs; and it ends with application deployment. The book emphasizes and clearly documents areas such as Globalization, Localization, and developing multi-lingual applications, and includes a special discussion about Right-To-Left (RTL) support for APEX applications, documented here for the first time. Throughout the book, there are many screenshots and snippets of code, taken from working APEX applications. The book is accompanied by demo APEX applications that you can download and install in your APEX environment, thoroughly analyze, and learn from as you read the book. What you will learn from this book Fully utilize the Web development aspects of APEX by getting familiar with necessary skills such as HTML, the DOM, CSS, and JavaScript Understand important concepts of APEX such as Session State, Substitution Strings, the Shortcuts mechanism, and more Create the APEX application building blocks, like pages, items, processes, data validation, shared components, and others, and use them to implement the User Interface and the application (business) logic Generate APEX Forms and modify them to your needs using the APEX wizards Build, display, and validate a Tabular Form, manually as well as using a wizard Create and modify Interactive Reports Understand the AJAX concepts, such as XML Http Request, communication, and data format, in order to enhance users' experience, and to optimize application performance Secure your applications using Authentication Schemes, Authorization Schemes, Session State Protection, and Security Attributes Build localized and/or multi-lingual applications using the APEX Globalization support, including the APEX built-in translation mechanism Convert Microsoft Access and Oracle Forms applications to APEX applications Explore APEX SQL Workshop via its modules such as Object Browser, SQL Commands, SQL Scripts, and Query Builder, and learn how to use them to build the database infrastructure and support for your application Implement AJAX in APEX with the help of detailed working examples Approach This book is a practical guide that not only shows you how to do things, but also makes you understand how things really work, so you'll be able to develop your own applications. It uses many screenshots, examples, and real-time "APEX code", some of which is documented for the first time. Who this book is written for This book is for developers, in general, and web developers, in particular, who wish to learn how to develop data-centric web applications in the Oracle environment. It is also for novice APEX developers, who wish to learn how to use and best utilize the APEX environment, as well as for more experience APEX developers who wish to improve their knowledge and understanding of APEX and its capabilities, and learn from the experience of others. It assumes basic knowledge of HTML, SQL, and PL/SQL. Basic JavaScript understanding is an advantage, and in general can make your life much easier as an APEX developer. About the Author Arie Geller is an independent IT consultant, with more than 30 years of experience with systems analysis, software development, IT infrastructure, etc. He started to use HTML DB 1.6 (the former name of APEX) to develop data centric Web applications in the Oracle environment, and continue doing so, with all the following versions, until today. Arie has specialized in developing Right-To-Left-oriented applications, and he brings his expertise and experience in this field into the book. Arie is also an active member of the APEX community on OTN, where he assists other members and shares his knowledge and experience as much as he can. Matthew Lyon is a Senior Consultant at SRA Information Technology in Adelaide, South Australia. His involvement in enterprise software development extends across analysis, design, development, architecture, and project management, giving him a deep appreciation of the effective use of software technology. He has experie Table of Contents Preface Chapter 1: An Introduction to APEX Chapter 2: What we need to know to effectively use APEX Chapter 3: APEX Basic Concepts Chapter 4: The Application Builder Basic Concepts and Building Blocks Chapter 5: APEX Items Chapter 6: APEX Buttons Chapter 7: APEX Computations Chapter 8: APEX Validations Chapter 9: APEX Processes Chapter 10: APEX Branches Chapter 11: APEX SQL Workshop Chapter 12: APEX Forms Chapter 13: APEX Reports Chapter 14: Tabular Forms Chapter 15: Calendars Chapter 16: Interactive Reports Chapter 17: AJAX with APEX Chapter 18: Globalization and Localization With APEX Applications Chapter 19: Right-To-Left Support in APEX Chapter 20: Deploying APEX Applications Chapter 21: The APEX Runtime Environment Chapter 22: Security Chapter 23: Application Conversion Chapter 24: APEX Best Practices Appendix: APEX Installation, Upgrade, and Configuration Tips Index