SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK EXPERT ORACLE APPLICATION EXPRESS
SUMMARY
-
Items Found: 542
- Chapter 1: OHS,EPG,and APEX Listener Compared
- Why Should I Care About This Chapter?
- Web Server Basics
- The Oracle HTTP Server (OHS)
- Installing the OHS
- Configuring the OHS
- Digging into HTTPD.CONF
- Configuring Virtual Hosts
- Prefork or Multi-Processing Module?
- Web Server Compression
- Expiry Headers.
- Embedded PL/SQL Gateway
- Compression and Expiry Headers with the EPG
- Configuring SHARED_SERVERS.
- Configuring EPG Parameters and DADS
- Debugging Issues with the EPG
- Configuring Virtual Hosts with the EPG.
- The APEX Listener
- Stand-Alone Installation
- Installing via Glassfish or Web Logic Server.
- Compression with the APEX Listener
- Interesting APEX Listener Features
- Conclusion
- Chapter 2: Oracle APEX 4.0 Charts Inside Out
- HTML Charts
- Using the HTML Charts Wizard
- The Result.
- Debugging and Performance
- Behind the Scenes
- Inline HTML Charts in Report.
- Flash Charts.
- Background
- Creating a Flash Chart
- The Result.
- Understanding the Chart Region.
- Understanding the Chart Attributes
- Adding Multiple Series and Combined Charts
- Different Flash Chart Types
- Behind the Scenes
- Debug and Performance
- Upgrading Oracle APEX 3.x Flash and SVG Charts.
- Screen Reader Mode and Charts
- Extending Flash Charts
- Customizing Charts by Using Custom XML.
- Customizing Charts by Using Custom XML,Dynamic Actions,and JavaScript
- Creating Charts Manually
- Drill-Down Charts,Dashboards,and Interactivity.
- Simple Dashboard with Submit
- Simple Dashboard with JavaScript
- Complex Dashboard with Actions.
- Most Common Issues
- Search for a Specific Feature
- Invalid #HOST# with Reverse Proxy or HTTPS.
- Flash Security Error
- Charts in the Future
- Resources
- Conclusion
- Chapter 3: Tabular Forms
- Changes in APEX 4.0
- Constraints
- Purpose of Tabular Forms
- Tabular Forms Are Not Spreadsheets.
- New Features in APEX 4
- New Item Types.
- Declarative Validations
- Other Features.
- Future Features We’d Like to See
- Custom Coding in Tabular Forms.
- Processing the Correct Rows
- Data Integrity
- Manual Tabular Forms.
- Tabular Forms and Collections
- Interesting Techniques
- Simple Autocomplete
- Autocomplete Returning Key Value
- Clone Rows.
- Chapter 4: Team Development
- Milestones
- The Basics
- Extending Milestone Functionality
- Features.
- The Basics
- Extending the Features Functionality
- To Do’s
- The Basics
- Extending the To Do Functionality
- Bugs.
- Feedback
- Feedback Process
- Enable Feedback
- Exporting Feedback to Development
- Importing Feedback into Development
- Processing Feedback
- Exporting Response to Deployment.
- Importing Response into Deployment.
- Extending Feedback: Create a Report
- Extending Feedback: Feeding Back the Follow Up.
- Further Enhancements
- Wrap Up
- Chapter 5: Globalization
- Loading Languages
- Translating Applications
- Application Language Derived From.
- Mapping.
- CSV Encoding
- Translating an Application.
- Manually Translate an Application
- Translating Data in the Database
- Dynamic Translations
- Translating APEX Internal Text
- Copying Translations to Other Environments.
- Copying Only the Applications.
- Copy the Primary Application and Publish.
- Changing the Application ID
- Localization.
- SINCE Format Mask.
- Numeric Formats.
- Time Zones and Territories.
- Switching Languages
- Translation logs
- Developer Log.
- Dashboard
- Conclusion
- Chapter 6: Debugging
- Principles of Code Instrumentation.
- Debugging Basics.
- Page Processing and Rendering.
- Enabling Debug
- Debug Information.
- Benefits of Debug Mode
- Graphs and Charts
- Interactive Reports
- APEX Debugging API
- APEX_DEBUG_MESSAGE
- Programmatic Debugging.
- Instrumenting Your Own Code
- The Data Behind Debugging
- Tables and View
- Examining the Debug Data
- Using Debug Data for More Than Debugging
- Debugging Dynamic Actions
- What Debug Doesn’t Capture.
- AJAX Calls.
- FLASH Charts.
- Reports
- Chapter 7: Dynamic Actions
- Custom JavaScript vs. Dynamic Actions
- Manual (Old Method)
- Dynamic Action (New Method)
- Dynamic Actions in Detail
- Identification.
- When
- Advanced.
- Actions
- Dynamic Actions in Action
- Business Case
- Setup
- Create Department Employee Report
- Refresh Department Employees Report
- Highlight Row
- Row Click
- Emphasize Employee Change
- Modal Window.
- Chapter 8: Security
- Tools and Techniques.
- Authorized Access
- An APEX Example
- The Real Solution
- Denial of Service
- Denial of Service in an APEX Environment
- The Details
- The Fix
- SQL Injection
- A SQL Injection Primer.
- Custom Developed Applications vs. Commercial Off the Shelf Products
- SQL Injection in an APEX Environment
- Password Cracking
- Cross Site Scripting
- Conclusion
- Chapter 9: Lifecycle Management
- Challenges
- Working Concurrently on the Same Source Code.
- Propagating All Required Changes for a New Release.
- Parallel Development on Different Application Versions
- What Is the Current Status?
- Which Requirements Were Implemented in This Release?
- The Sample Application
- The Approach.
- Version Numbering Scheme and the Overall Delivery Process
- Storing Files on the Application Server
- Requirements for Designing the Server Environments.
- Project Management Related Aspects.
- Version Control
- Naming Conventions.
- Naming Conventions for the File System.
- Rollout Procedures
- Initialize Patch
- Making Changes.
- Finalizing the Patch
- Installation in the Test Environment
- Update the Documentation.
- Installation in the Production Environment.
- Chapter 10: Working with APEX Collections
- When to Use APEX Collections.
- Session State Management: A Quick Overview.
- Session State Managed Tables
- Logically Walking Through a Web Shopping Cart Implementation.
- A Look Under the Covers
- Private Collections Objects Inside the APEX Engine
- Public Collections Objects Inside the APEX Engine
- Getting Started with Collections
- Initializing a Collection
- Adding and Removing Data from Collections
- Using the Collection
- Expanding Our Example
- Passing Data to the Form
- Creating a Tabular Form to Be Validated
- Collecting and Processing Submitted Data
- Chapter 11: Plug-Ins.
- The APEX Plug-in Architecture
- Create/Edit Page for Plug-ins
- PL/SQL APIs
- Other Tools of the Trade
- jQuery UI Widget Factory
- jQuery UI CSS Framework
- Plug-in Tutorials
- Developing a Process Plug-in.
- Developing a Dynamic Action Plug-in
- Developing an Item Plug-in
- Developing a Region Plug-in
- Best Practices for Developing Plug-ins
- Conclusion
- Chapter 12: Architecture
- Oracle APEX Engine
- Installing and Upgrading.
- Applications
- Application Pages
- Session State Management.
- Connection Management
- Application Logging
- Running SQL and PL/SQL Contained Within an Application.
- Workspaces and Multi-Tenancy
- Automatic Data Manipulation Language (DML)
- Application Extensibility
- Customizing User Interface Templates.
- Using Static HTML
- Using PL/SQL to Generate HTML
- Plug-Ins
- Separation of Presentation and Logic.
- Conclusion
- Chapter 13: Advanced Interactive Reporting.
- Creating a Report
- Data Formatting
- Report and Column Attributes
- Column Groups
- Including Links
- Filtering Using Items
- Column List of Values
- Creating Default and Saved Reports.
- Charting
- Linking to Saved Interactive Reports.
- Report Settings
- Report-Level Settings
- Column-Level Settings
- Utilities
- APEX_UTIL functions
- User Interface Defaults
- Activity Log
- Security.
- Performance
- Conclusion
- Chapter 1: OHS,EPG,and APEX Listener Compared
- Why Should I Care About This Chapter?
- Web Server Basics
- The Oracle HTTP Server (OHS)
- Installing the OHS
- Configuring the OHS
- Digging into HTTPD.CONF
- Configuring Virtual Hosts
- Prefork or Multi-Processing Module?
- Web Server Compression
- Expiry Headers.
- Embedded PL/SQL Gateway
- Compression and Expiry Headers with the EPG
- Configuring SHARED_SERVERS.
- Configuring EPG Parameters and DADS
- Debugging Issues with the EPG
- Configuring Virtual Hosts with the EPG.
- The APEX Listener
- Stand-Alone Installation
- Installing via Glassfish or Web Logic Server.
- Compression with the APEX Listener
- Interesting APEX Listener Features
- Conclusion
- Chapter 2: Oracle APEX 4.0 Charts Inside Out
- HTML Charts
- Using the HTML Charts Wizard
- The Result.
- Debugging and Performance
- Behind the Scenes
- Inline HTML Charts in Report.
- Flash Charts.
- Background
- Creating a Flash Chart
- The Result.
- Understanding the Chart Region.
- Understanding the Chart Attributes
- Adding Multiple Series and Combined Charts
- Different Flash Chart Types
- Behind the Scenes
- Debug and Performance
- Upgrading Oracle APEX 3.x Flash and SVG Charts.
- Screen Reader Mode and Charts
- Extending Flash Charts
- Customizing Charts by Using Custom XML.
- Customizing Charts by Using Custom XML,Dynamic Actions,and JavaScript
- Creating Charts Manually
- Drill-Down Charts,Dashboards,and Interactivity.
- Simple Dashboard with Submit
- Simple Dashboard with JavaScript
- Complex Dashboard with Actions.
- Most Common Issues
- Search for a Specific Feature
- Invalid #HOST# with Reverse Proxy or HTTPS.
- Flash Security Error
- Charts in the Future
- Resources
- Conclusion
- Chapter 3: Tabular Forms
- Changes in APEX 4.0
- Constraints
- Purpose of Tabular Forms
- Tabular Forms Are Not Spreadsheets.
- New Features in APEX 4
- New Item Types.
- Declarative Validations
- Other Features.
- Future Features We’d Like to See
- Custom Coding in Tabular Forms.
- Processing the Correct Rows
- Data Integrity
- Manual Tabular Forms.
- Tabular Forms and Collections
- Interesting Techniques
- Simple Autocomplete
- Autocomplete Returning Key Value
- Clone Rows.
- Chapter 4: Team Development
- Milestones
- The Basics
- Extending Milestone Functionality
- Features.
- The Basics
- Extending the Features Functionality
- To Do’s
- The Basics
- Extending the To Do Functionality
- Bugs.
- Feedback
- Feedback Process
- Enable Feedback
- Exporting Feedback to Development
- Importing Feedback into Development
- Processing Feedback
- Exporting Response to Deployment.
- Importing Response into Deployment.
- Extending Feedback: Create a Report
- Extending Feedback: Feeding Back the Follow Up.
- Further Enhancements
- Wrap Up
- Chapter 5: Globalization
- Loading Languages
- Translating Applications
- Application Language Derived From.
- Mapping.
- CSV Encoding
- Translating an Application.
- Manually Translate an Application
- Translating Data in the Database
- Dynamic Translations
- Translating APEX Internal Text
- Copying Translations to Other Environments.
- Copying Only the Applications.
- Copy the Primary Application and Publish.
- Changing the Application ID
- Localization.
- SINCE Format Mask.
- Numeric Formats.
- Time Zones and Territories.
- Switching Languages
- Translation logs
- Developer Log.
- Dashboard
- Conclusion
- Chapter 6: Debugging
- Principles of Code Instrumentation.
- Debugging Basics.
- Page Processing and Rendering.
- Enabling Debug
- Debug Information.
- Benefits of Debug Mode
- Graphs and Charts
- Interactive Reports
- APEX Debugging API
- APEX_DEBUG_MESSAGE
- Programmatic Debugging.
- Instrumenting Your Own Code
- The Data Behind Debugging
- Tables and View
- Examining the Debug Data
- Using Debug Data for More Than Debugging
- Debugging Dynamic Actions
- What Debug Doesn’t Capture.
- AJAX Calls.
- FLASH Charts.
- Reports
- Chapter 7: Dynamic Actions
- Custom JavaScript vs. Dynamic Actions
- Manual (Old Method)
- Dynamic Action (New Method)
- Dynamic Actions in Detail
- Identification.
- When
- Advanced.
- Actions
- Dynamic Actions in Action
- Business Case
- Setup
- Create Department Employee Report
- Refresh Department Employees Report
- Highlight Row
- Row Click
- Emphasize Employee Change
- Modal Window.
- Chapter 8: Security
- Tools and Techniques.
- Authorized Access
- An APEX Example
- The Real Solution
- Denial of Service
- Denial of Service in an APEX Environment
- The Details
- The Fix
- SQL Injection
- A SQL Injection Primer.
- Custom Developed Applications vs. Commercial Off the Shelf Products
- SQL Injection in an APEX Environment
- Password Cracking
- Cross Site Scripting
- Conclusion
- Chapter 9: Lifecycle Management
- Challenges
- Working Concurrently on the Same Source Code.
- Propagating All Required Changes for a New Release.
- Parallel Development on Different Application Versions
- What Is the Current Status?
- Which Requirements Were Implemented in This Release?
- The Sample Application
- The Approach.
- Version Numbering Scheme and the Overall Delivery Process
- Storing Files on the Application Server
- Requirements for Designing the Server Environments.
- Project Management Related Aspects.
- Version Control
- Naming Conventions.
- Naming Conventions for the File System.
- Rollout Procedures
- Initialize Patch
- Making Changes.
- Finalizing the Patch
- Installation in the Test Environment
- Update the Documentation.
- Installation in the Production Environment.
- Chapter 10: Working with APEX Collections
- When to Use APEX Collections.
- Session State Management: A Quick Overview.
- Session State Managed Tables
- Logically Walking Through a Web Shopping Cart Implementation.
- A Look Under the Covers
- Private Collections Objects Inside the APEX Engine
- Public Collections Objects Inside the APEX Engine
- Getting Started with Collections
- Initializing a Collection
- Adding and Removing Data from Collections
- Using the Collection
- Expanding Our Example
- Passing Data to the Form
- Creating a Tabular Form to Be Validated
- Collecting and Processing Submitted Data
- Chapter 11: Plug-Ins.
- The APEX Plug-in Architecture
- Create/Edit Page for Plug-ins
- PL/SQL APIs
- Other Tools of the Trade
- jQuery UI Widget Factory
- jQuery UI CSS Framework
- Plug-in Tutorials
- Developing a Process Plug-in.
- Developing a Dynamic Action Plug-in
- Developing an Item Plug-in
- Developing a Region Plug-in
- Best Practices for Developing Plug-ins
- Conclusion
- Chapter 12: Architecture
- Oracle APEX Engine
- Installing and Upgrading.
- Applications
- Application Pages
- Session State Management.
- Connection Management
- Application Logging
- Running SQL and PL/SQL Contained Within an Application.
- Workspaces and Multi-Tenancy
- Automatic Data Manipulation Language (DML)
- Application Extensibility
- Customizing User Interface Templates.
- Using Static HTML
- Using PL/SQL to Generate HTML
- Plug-Ins
- Separation of Presentation and Logic.
- Conclusion
- Chapter 13: Advanced Interactive Reporting.
- Creating a Report
- Data Formatting
- Report and Column Attributes
- Column Groups
- Including Links
- Filtering Using Items
- Column List of Values
- Creating Default and Saved Reports.
- Charting
- Linking to Saved Interactive Reports.
- Report Settings
- Report-Level Settings
- Column-Level Settings
- Utilities
- APEX_UTIL functions
- User Interface Defaults
- Activity Log
- Security.
- Performance
- Conclusion
