Atnaujinkite slapukų nuostatas

Expert Oracle Application Express 1st ed. [Minkštas viršelis]

3.67/5 (9 ratings by Goodreads)
, , , , , , , , ,
  • Formatas: Paperback / softback, 620 pages, aukštis x plotis: 254x178 mm, weight: 1155 g, XXVIII, 620 p., 1 Paperback / softback
  • Išleidimo metai: 14-Jun-2011
  • Leidėjas: APress
  • ISBN-10: 1430235128
  • ISBN-13: 9781430235125
Kitos knygos pagal šią temą:
Expert Oracle Application Express 1st ed.Didesnis paveikslėlis
  • Formatas: Paperback / softback, 620 pages, aukštis x plotis: 254x178 mm, weight: 1155 g, XXVIII, 620 p., 1 Paperback / softback
  • Išleidimo metai: 14-Jun-2011
  • Leidėjas: APress
  • ISBN-10: 1430235128
  • ISBN-13: 9781430235125
Kitos knygos pagal šią temą:
Pastovi nuoroda: https://www.kriso.lt/db/9781430235125.html
Raktažodžiai:
Expert Oracle Application Express brings you groundbreaking insights into developing with Oracles enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracles powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users.  





The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product singdeveloping secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding scalability, globalization, configuration and lifecycle management, and more. Youll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development.











Presents best-practices and development insights from leading experts in the field Addresses globalization, scalability, security, and other concerns of enterprise-level development Shows how to customize APEX for your own application needs
Foreword xvi
About the Authors xxii
About the Technical Reviewers xxvi
Acknowledgments xxvii
Chapter 1 OHS, EPG, and APEX Listener Compared
1(72)
Why Should I Care About This
Chapter?
1(1)
Web Server Basics
2(1)
The Oracle HTTP Server (OHS)
3(32)
Installing the OHS
3(5)
Configuring the OHS
8(5)
Digging into HTTPD.CONF
13(3)
Configuring Virtual Hosts
16(4)
Prefork or Multi-Processing Module?
20(2)
Web Server Compression
22(8)
Expiry Headers
30(5)
Embedded PL/SQL Gateway
35(15)
Compression and Expiry Headers with the EPG
38(1)
Configuring SHARED_SERVERS
39(3)
Configuring EPG Parameters and DADS
42(4)
Debugging Issues with the EPG
46(2)
Configuring Virtual Hosts with the EPG
48(2)
The APEX Listener
50(21)
Stand-Alone Installation
51(9)
Installing via Glassfish or Web Logic Server
60(1)
Compression with the APEX Listener
61(3)
Interesting APEX Listener Features
64(7)
Conclusion
71(2)
Chapter 2 Oracle APEX 4.0 Charts Inside Out
73(82)
HTML Charts
74(4)
Using the HTML Charts Wizard
74(1)
The Result
75(1)
Debugging and Performance
75(1)
Behind the Scenes
76(1)
Inline HTML Charts in Report
76(2)
Flash Charts
78(20)
Background
78(1)
Creating a Flash Chart
79(5)
The Result
84(1)
Understanding the Chart Region
85(4)
Understanding the Chart Attributes
89(9)
Adding Multiple Series and Combined Charts
98(5)
Different Flash Chart Types
103(2)
Behind the Scenes
105(6)
Debug and Performance
111(5)
Upgrading Oracle APEX 3.x Flash and SVG Charts
116(2)
Screen Reader Mode and Charts
118(2)
Extending Flash Charts
120(14)
Customizing Charts by Using Custom XML
121(3)
Customizing Charts by Using Custom XML, Dynamic Actions, and JavaScript
124(4)
Creating Charts Manually
128(6)
Drill-Down Charts, Dashboards, and Interactivity
134(16)
Simple Dashboard with Submit
134(3)
Simple Dashboard with JavaScript
137(4)
Complex Dashboard with Actions
141(9)
Most Common Issues
150(1)
Search for a Specific Feature
150(1)
Invalid #H0ST# with Reverse Proxy or HTTPS
150(1)
Flash Security Error
151(1)
Charts in the Future
151(1)
Resources
152(1)
Conclusion
153(2)
Chapter 3 Tabular Forms
155(56)
Changes in APEX 4.0
155(1)
Constraints
155(1)
Purpose of Tabular Forms
156(1)
Tabular Forms Are Not Spreadsheets
157(1)
New Features in APEX 4
157(13)
New Item Types
157(9)
Declarative Validations
166(3)
Other Features
169(1)
Future Features We'd Like to See
170(1)
Custom Coding in Tabular Forms
170(29)
Processing the Correct Rows
170(4)
Data Integrity
174(4)
Manual Tabular Forms
178(7)
Tabular Forms and Collections
185(14)
Interesting Techniques
199(10)
Simple Autocomplete
199(3)
Autocomplete Returning Key Value
202(6)
Clone Rows
208(1)
Summary
209(2)
Chapter 4 Team Development
211(30)
Milestones
211(4)
The Basics
212(2)
Extending Milestone Functionality
214(1)
Features
215(5)
The Basics
215(4)
Extending the Features Functionality
219(1)
To Do's
220(7)
The Basics
220(7)
Extending the To Do Functionality
221
Bugs
227(2)
Feedback
229(11)
Feedback Process
229(1)
Enable Feedback
230(2)
Exporting Feedback to Development
232(1)
Importing Feedback into Development
233(1)
Processing Feedback
233(2)
Exporting Response to Deployment
235(1)
Importing Response into Deployment
235(1)
Extending Feedback: Create a Report
236(2)
Extending Feedback: Feeding Back the Follow Up
238(1)
Further Enhancements
238(2)
Wrap Up
240(1)
Chapter 5 Globalization
241(30)
Loading Languages
241(3)
Translating Applications
244(11)
Application Language Derived From
245(2)
Mapping
247(1)
CSV Encoding
248(1)
Translating an Application
249(4)
Manually Translate an Application
253(2)
Translating Data in the Database
255(1)
Dynamic Translations
255(2)
Translating APEX Internal Text
257(3)
Copying Translations to Other Environments
260(1)
Copying Only the Applications
260(1)
Copy the Primary Application and Publish
260(1)
Changing the Application ID
261(1)
Localization
261(4)
SINCE Format Mask
262(1)
Numeric Formats
262(1)
Time Zones and Territories
263(2)
Switching Languages
265(2)
Translation logs
267(2)
Developer Log
267(1)
Dashboard
268(1)
Conclusion
269(2)
Chapter 6 Debugging
271(38)
Principles of Code Instrumentation
271(1)
Debugging Basics
272(9)
Page Processing and Rendering
272(3)
Enabling Debug
275(1)
Debug Information
276(5)
Benefits of Debug Mode
281(4)
Graphs and Charts
281(2)
Interactive Reports
283(2)
APEX Debugging API
285(14)
APEX_DEBUG_MESSAGE
286(5)
Programmatic Debugging
291(3)
Instrumenting Your Own Code
294(5)
The Data Behind Debugging
299(4)
Tables and View
299(2)
Examining the Debug Data
301(2)
Using Debug Data for More Than Debugging
303(1)
Debugging Dynamic Actions
303(3)
What Debug Doesn't Capture
306(1)
AJAX Calls
306(1)
FLASH Charts
306(1)
Reports
307(1)
Summary
307(2)
Chapter 7 Dynamic Actions
309(40)
Custom JavaScript vs. Dynamic Actions
309(6)
Manual (Old Method)
310(1)
Dynamic Action (New Method)
311(4)
Dynamic Actions in Detail
315(14)
Identification
318(1)
When
318(4)
Advanced
322(1)
Actions
323(6)
Dynamic Actions in Action
329(18)
Business Case
329(1)
Setup
330(1)
Create Department Employee Report
331(2)
Refresh Department Employees Report
333(3)
Highlight Row
336(2)
Row Click
338(2)
Emphasize Employee Change
340(2)
Modal Window
342(5)
Summary
347(2)
Chapter 8 Security
349(28)
Tools and Techniques
349(5)
Authorized Access
354(5)
An APEX Example
354(4)
The Real Solution
358(1)
Denial of Service
359(3)
Denial of Service in an APEX Environment
359(1)
The Details
359(2)
The Fix
361(1)
SQL Injection
362(6)
A SQL Injection Primer
362(3)
Custom Developed Applications vs. Commercial Off the Shelf Products
365(1)
SQL Injection in an APEX Environment
366(2)
Password Cracking
368(3)
Cross Site Scripting
371(4)
Conclusion
375(2)
Chapter 9 Lifecycle Management
377(46)
Challenges
378(2)
Working Concurrently on the Same Source Code
378(1)
Propagating All Required Changes for a New Release
378(1)
Parallel Development on Different Application Versions
379(1)
What Is the Current Status?
379(1)
Which Requirements Were Implemented in This Release?
379(1)
The Sample Application
380(1)
The Approach
381(8)
Version Numbering Scheme and the Overall Delivery Process
381(1)
Storing Files on the Application Server
382(1)
Requirements for Designing the Server Environments
383(6)
Project Management Related Aspects
389(21)
Version Control
389(5)
Naming Conventions
394(8)
Naming Conventions for the File System
402(8)
Rollout Procedures
410(12)
Initialize Patch
411(3)
Making Changes
414(2)
Finalizing the Patch
416(2)
Installation in the Test Environment
418(1)
Update the Documentation
419(1)
Installation in the Production Environment
420(2)
Summary
422(1)
Chapter 10 Working with APEX Collections
423(18)
When to Use APEX Collections
423(1)
Session State Management: A Quick Overview
424(1)
Session State Managed Tables
424(1)
Logically Walking Through a Web Shopping Cart Implementation
424(1)
A Look Under the Covers
424(5)
Private Collections Objects Inside the APEX Engine
425(2)
Public Collections Objects Inside the APEX Engine
427(2)
Getting Started with Collections
429(11)
Initializing a Collection
429(1)
Adding and Removing Data from Collections
430(3)
Using the Collection Contents
433(1)
Expanding Our Example
434(1)
Passing Data to the Form
434(2)
Creating a Tabular Form to Be Validated
436(1)
Collecting and Processing Submitted Data
437(3)
Summary
440(1)
Chapter 11 Plug-Ins
441(74)
The APEX Plug-in Architecture
441(12)
Create/Edit Page for Plug-ins
442(8)
PL/SQL APIs
450(3)
Other Tools of the Trade
453(6)
jQuery UI Widget Factory
454(3)
jQuery UI CSS Framework
457(2)
Plug-in Tutorials
459(52)
Developing a Process Plug-in
459(9)
Developing a Dynamic Action Plug-in
468(8)
Developing an Item Plug-in
476(19)
Developing a Region Plug-in
495(16)
Best Practices for Developing Plug-ins
511(2)
Conclusion
513(2)
Chapter 12 Architecture
515(18)
Oracle APEX Engine
516(1)
Installing and Upgrading
517(1)
Applications
518(1)
Application Pages
519(8)
Session State Management
521(4)
Connection Management
525(1)
Application Logging
525(1)
Running SQL and PL/SQL Contained Within an Application
526(1)
Workspaces and Multi-Tenancy
526(1)
Automatic Data Manipulation Language (DML)
527(1)
Application Extensibility
528(2)
Customizing User Interface Templates
528(1)
Using Static HTML
529(1)
Using PL/SQL to Generate HTML
529(1)
Plug-Ins
530(1)
Separation of Presentation and Logic
530(1)
Conclusion
531(2)
Chapter 13 Advanced Interactive Reporting
533(38)
Creating a Report
533(1)
Data Formatting
534(5)
Report and Column Attributes
535(2)
Column Groups
537(2)
Including Links
539(9)
Filtering Using Items
545(1)
Column List of Values
546(2)
Creating Default and Saved Reports
548(2)
Charting
550(2)
Linking to Saved Interactive Reports
552(2)
Report Settings
554(3)
Report-Level Settings
554(3)
Column-Level Settings
557(1)
Utilities
557(10)
APEX_UTIL functions
560(5)
User Interface Defaults
565(1)
Activity Log
566(1)
Security
567(1)
Performance
568(1)
Conclusion
569(2)
Index 571
John Edward Scott has been using Oracle since version 7 (around 1993), and has used pretty much every release since then. He has had the good fortune to work on a wide range of projects for a varied group of clients. He was lucky enough to start working with Oracle Application Express when it was first publicly released, and has worked with it nearly every day since (and loves it). John is an Oracle ACE Director and was named Application Express Developer of the Year in 2006 by Oracle Magazine. He is also the cofounder of ApexEvangelists (Apex-Evangelists.com), a company that specializes in providing training, development, and consulting specifically for the Oracle Application Express product. You can contact John at john.scott@apex-evangelists.com.