Pro Oracle Application Express

Cover -- TOC$Contents -- Foreword -- About the Authors -- About the Technical Reviewer -- Acknowledgments -- Preface -- CH$CHAPTER 1 Development Best Practices -- APEX Installation Decisions -- Application Development Considerations -- Users and Administrators -- Workspaces and Schemas -- Application Deployment -- Application Portability and Code Reuse -- Performance Considerations. -- Bind Variables -- Report Pagination Style -- Error and Exception Handling -- Packaged Code -- Summary -- CH$CHAPTER 2 Migrating to APEX from Desktop Systems -- Excel Migration -- Creating a New Application Based on a Spreadsheet -- Running the New Application -- Customizing the Application -- Exporting Data to a Spreadsheet -- Access Migration -- Using the Access Export Option -- Using the ODBC Database Export Method -- Using Oracle Migration Workbench -- Migrating the Application -- Migration from Other Systems -- Migrating from a System Using an Oracle Database -- Migrating from a System Using Another Database -- Migration with SQL Developer -- Connecting to a Migration Source -- Running the Migration Wizard -- Verifying the Migration -- Summary -- CH$CHAPTER 3 Authentication and User Management -- Preconfigured Authentication Schemes -- Open Door Credentials -- No Authentication -- Application Express Account Credentials -- Creating New Application Users -- Creating Groups -- Controlling Authentication with Groups -- Maintaining Cookie Users Within Your Application -- Database Account Authentication -- Custom Authentication -- Creating the User Repository -- Creating a New Authentication Scheme -- Regarding Index Usage -- Hash Rather Than Crypt -- Implementing Locked User Accounts -- Automating User Registration -- Implementing Session Timeouts -- Summary -- CH$CHAPTER 4 Conditions and Authorization Schemes -- Conditions -- Specifying Condition Types -- Using Conditions Appropriately -- Authorization Schemes -- Creating an Authorization Scheme -- Protecting Your Resources -- To Cache or Not to Cache -- Resetting the Caching -- Summary -- CH$CHAPTER 5 Data Security -- URLs and Security -- Understanding the URL Syntax -- Manipulating the URL -- Session State Protection -- Enabling Session State Protection -- Configuring Session State Protection -- Virtual Private Database -- Implementing VPD -- Using Contexts with VPD -- Using Advanced VPD Features -- VPD Best Practices -- Auditing -- Enabling Auditing -- Viewing Audit Data -- Summary -- CH$CHAPTER 6 Navigation and Layout -- Tabs -- Understanding Tab States: Current and Noncurrent -- Using Standard Tabs -- Using Parent Tabs -- Navigation Bars -- Accessing Navigation Bar Entries -- Creating Navigation Bar Entries -- Performing an Action on the Current Page -- Breadcrumbs -- Accessing Breadcrumb Entries -- Using Dynamic Breadcrumb Entries -- Displaying Breadcrumbs -- Lists -- Accessing List Entries -- Creating a Menu Using a List -- Tracking Clicks on List Entries -- Using User-Defined Attributes for List Entries -- Trees -- Creating a Table for the Tree Entries -- Creating the Tree Component -- Enabling and Disabling Tree Entries -- Page Zero --T$18506.