Muutke küpsiste eelistusi

Beginning Oracle Application Express 4.2 2nd ed. [Pehme köide]

4.00/5 (5 hinnangut Goodreads-ist)
, , , ,
  • Formaat: Paperback / softback, 448 pages, kõrgus x laius: 254x178 mm, kaal: 840 g, 555 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 02-Apr-2013
  • Kirjastus: APress
  • ISBN-10: 1430257342
  • ISBN-13: 9781430257349
Teised raamatud teemal:
  • Pehme köide
  • Hind: 37,70 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 44,35 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 3-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Beginning Oracle Application Express 4.2 2nd ed.Suurem pilt
  • Formaat: Paperback / softback, 448 pages, kõrgus x laius: 254x178 mm, kaal: 840 g, 555 Illustrations, black and white, 1 Paperback / softback
  • Ilmumisaeg: 02-Apr-2013
  • Kirjastus: APress
  • ISBN-10: 1430257342
  • ISBN-13: 9781430257349
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781430257349.html
Märksõnad:

Beginning Oracle Application Express 4.2 introduces version 4.2 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4.2 brings extensive new Flash and HTML 5 charting capabilities, enhanced themes for mobile applications usable from phones and tablets, RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface.

Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX,Beginning Oracle Application Express 4.2 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company.

  • Covers brand-new functionality in APEX 4.2
  • Provides fully documented and explained example code
  • Guides you through creating a working and fully deployable application
About the Authors xix
About the Technical Reviewer xxi
Acknowledgments xxiii
Chapter 1 An Introduction to APEX 4.2
1(6)
What Is APEX?
1(1)
A Brief History of APEX
2(2)
Ancient History
2(1)
More Recent History
2(1)
APEX 4 and the Future
3(1)
What You Need to Get Started
4(1)
Access to an APEX Instance
4(1)
Web Browser
5(1)
SQL Developer
5(1)
Summary
5(2)
Chapter 2 A Developer's Overview
7(22)
The Anatomy of a Workspace
7(4)
APEX Users
8(1)
Applications, Pages, Regions, and Items
8(1)
Workspaces, Applications, and Schemas
9(2)
A Final Word on Workspaces
11(1)
A Tour of the APEX Modules
11(17)
The Home Page
13(2)
Application Builder
15(2)
SQL Workshop
17(11)
Administration and Team Development
28(1)
Summary
28(1)
Chapter 3 Identifying the Problem and Designing the Solution
29(8)
Identifying System Requirements
29(3)
Never a Clean Slate
29(1)
A Broken System
30(1)
How Do You Fix Things?
30(2)
System Design with APEX in Mind
32(2)
Table Definition and User Interface Defaults
32(1)
APEX and Primary Keys
33(1)
Business Logic vs. User Interface Logic
33(1)
Placement of Database Objects
34(1)
Translating Theory to Practice
34(1)
Summary
35(2)
Chapter 4 SQL Workshop
37(18)
Creating Objects with the Object Browser
37(6)
Loading Data with the Data Workshop Utility
43(4)
Creating a Lookup Table
47(2)
Loading and Running SQL Scripts
49(2)
User Interface Defaults
51(3)
Understanding User Interface Defaults
52(1)
Defining UI Defaults for Tables
52(2)
Summary
54(1)
Chapter 5 Applications and Navigation
55(42)
The Create Application Wizard
55(13)
Sample and Packaged Applications
56(2)
Websheet Applications
58(1)
Database Applications from Spreadsheets
59(1)
Database Applications from Scratch
59(9)
HTML Regions
68(3)
Public Pages
71(2)
Navigation Bar Entries
73(3)
Global Pages
76(2)
Breadcrumb Regions
78(4)
Breadcrumb Entries
82(1)
Lists
83(4)
List Regions
87(3)
Template Positions
90(1)
Lists of Values
91(4)
Static List of Values
92(1)
Dynamic List of Values
93(2)
Summary
95(2)
Chapter 6 Forms and Reports---The Basics
97(56)
APEX Forms
97(2)
Form on a Table
99(11)
Creating a Form on a Table
99(5)
Modifying a Form on a Table
104(4)
Looking Behind the Scenes
108(2)
Form on a Procedure
110(4)
Creating a Form on a Procedure
110(2)
Modifying a Form on a Procedure
112(1)
Looking Behind the Scenes
113(1)
Master-Detail Report and Form
114(10)
Creating a Master-Detail Report and Form
114(4)
Modifying a Master-Detail Report
118(6)
Session State
124(4)
Understanding Session State
125(1)
Sharing Database Connections
125(1)
Setting and Retrieving Session State
126(1)
Viewing Session State
126(2)
APEX Items
128(2)
Page vs. Application Items
128(1)
The Importance of Bind Variables
129(1)
Built-in Items
129(1)
APEX URL Syntax
130(1)
Searchable APEX Reports
131(6)
Creating a Searchable APEX Report
131(2)
Adding Reset Pagination
133(1)
Looking Behind the Scenes---APEX Report
134(1)
Looking Behind the Scenes---APEX Master-Detail Forms
135(2)
More on APEX Forms
137(9)
Item Layout
137(2)
Placing Multiple Items in the Same Row
139(1)
Implementing LOVs
140(3)
Starting a New Grid
143(1)
Master-Detail Cleanup
144(2)
APEX Help
146(2)
Adding a Help Text Region
146(1)
Seeding Help Text
147(1)
Declarative BLOBs
148(3)
Summary
151(2)
Chapter 7 Forms and Reports---Advanced
153(50)
Tabular Forms
153(6)
Creating a Tabular Form
153(3)
Modifying a Tabular Form
156(3)
Looking Behind the Scenes
159(1)
Interactive Reports
159(29)
Creating an Interactive Report
160(2)
Running an Interactive Report
162(2)
Restricting Functionality by Report
164(1)
Restricting Functionality by Column
165(1)
Using the Column Heading Menu
165(1)
Searching by Column
166(3)
Selecting Columns
169(1)
Filtering
169(2)
Sorting
171(1)
Adding Breaks
172(1)
Highlighting
172(1)
Computing Columns
173(1)
Adding Aggregates
174(1)
Adding Charts to Interactive Reports
174(1)
Grouping
175(1)
Using Flashback
176(1)
Saving an Interactive Report
176(2)
Resetting an Interactive Report
178(1)
Getting Help
178(1)
Adding a Subscription
179(1)
Downloading
179(2)
Modifying an Interactive Report
181(6)
Looking Behind the Scenes
187(1)
Calendars
188(7)
Understanding Calendar Types
188(1)
Creating a Calendar
188(6)
Looking Behind the Scenes
194(1)
Charts
195(7)
Writing Queries for Charts
196(1)
Creating a Chart
196(3)
Filtering Data Using a Chart
199(2)
Looking Behind the Scenes
201(1)
Summary
202(1)
Chapter 8 Programmatic Elements
203(32)
Conditions
203(1)
Required Values
203(2)
Validations
205(10)
Item-Level Validation
205(5)
Page-Level Validation
210(2)
Tabular Form Validation
212(3)
Computations
215(5)
Execution
215(1)
Types
215(1)
Creating a Computation
216(4)
Processes
220(5)
Execution Points
220(1)
Process Types
221(1)
Processes in the Help Desk Application
221(4)
PL/SQL Regions
225(2)
Dynamic SQL
227(6)
Summary
233(2)
Chapter 9 Security
235(28)
User Maintenance Navigation
235(4)
User Maintenance Data Entry
239(6)
Authentication
245(1)
Custom Authentication Schemes
245(2)
Conditional Security
247(1)
Access Control
248(3)
Authorization
251(3)
Read-Only Items
254(2)
Data Security
256(4)
Session-State Protection
260(1)
Summary
261(2)
Chapter 10 Application Bundling and Deployment
263(20)
Identifying Application Components
263(11)
External Files
264(1)
Database Objects
264(4)
APEX-Based Files
268(3)
APEX Application Exports
271(3)
Supporting Objects
274(6)
Prerequisites
275(1)
Substitutions
276(1)
Build Options
276(1)
Validations
276(1)
Install
276(2)
Upgrade
278(1)
Deinstall
278(1)
Export
279(1)
Messages
279(1)
Importing
280(2)
Summary
282(1)
Chapter 11 Understanding Websheets
283(28)
Websheet Structure
283(2)
Navigation
285(2)
Content Navigation
285(2)
Structural Navigation
287(1)
Help
287(2)
Markup Syntax
289(1)
User Authentication
290(1)
User Authorization
291(5)
Sections
296(13)
Text Sections
296(3)
Navigation Sections
299(1)
Data Sections
300(9)
Chart Sections
309(1)
Annotations
309(1)
Administration
310(1)
Summary
310(1)
Chapter 12 A Websheet Example
311(18)
Setup
311(1)
Creating and Configuring a Websheet Application
312(3)
Adding Content to a Websheet
315(12)
Creating Data Grids
316(2)
Applying Constraints
318(1)
Adding Players
319(1)
Creating Alternate Default Reports
319(2)
Creating Page Sections
321(5)
SQL Tags
326(1)
Access Controls
327(1)
Summary
327(2)
Chapter 13 Extended Developer Tools
329(22)
Page Locks
329(3)
APEX Conflicts
329(1)
Locking an APEX Page
330(1)
Unlocking a Page
331(1)
Administering Page Locks
331(1)
Application and Page Groups
332(2)
Application Groups
332(2)
Page Groups
334(1)
APEX Views and the APEX Dictionary
334(4)
The APEX Schema
335(1)
APEX Views
335(3)
APEX Dictionary
338(1)
Searching in APEX
338(3)
APEX Finder
338(1)
Search Application
339(2)
Monitoring Your APEX Application
341(2)
Enabling Logging
341(1)
Using the Activity Logs
341(2)
Login Attempts
343(1)
APEX Advisor
343(1)
Build Options
344(5)
Understanding the Need
344(1)
Creating a Build Option
345(1)
Configuring Build Options
346(1)
Prompting for Build Option Status
346(1)
Applying Build Options
347(1)
Reporting on Build Option Utilization
348(1)
Page-Specific Utilities
349(1)
APEX and Oracle SQL Developer
349(1)
Integration
349(1)
Refactoring Support
350(1)
Summary
350(1)
Chapter 14 Managing Workspaces
351(18)
Learning About Your Environment
351(2)
Viewing Instance Information
352(1)
Checking the APEX Version
353(1)
Managing the Service
353(3)
Workspace Preferences
354(1)
Announcements
354(2)
Managing Meta Data
356(7)
Developer Activity and Click Count Logs
356(1)
Session State
357(1)
Application Cache
358(1)
Websheet Database Objects
358(1)
Application Build Status
358(1)
Application Models
359(1)
File Utilization
360(2)
Interactive Report Settings
362(1)
Managing Users and Groups
363(4)
Creating One User
363(1)
Creating Multiple Users
364(2)
Organizing Users into Groups
366(1)
Viewing Usage Reports and Dashboards
367(1)
Summary
367(2)
Chapter 15 Team Development
369(28)
Team Development Overview
369(2)
Team Development Interface
371(5)
APEX Home Page
371(1)
Team Development Home Page
372(1)
Common Design Elements
373(1)
Drilldown Functionality
374(2)
Tagging
376(1)
Features
376(4)
Features Tab
376(3)
History Tab
379(1)
Progress Log Tab
379(1)
Milestones
380(2)
Milestones Tab
380(1)
Milestones By Owner Tab
381(1)
Features by Milestone Tab
382(1)
To-Do Items
382(1)
Bugs
383(1)
Feedback
384(7)
Configuring Feedback
384(3)
Polishing the Feedback Page
387(3)
Viewing Feedback
390(1)
Responses to Feedback
391(1)
Communication Between Workspaces
391(1)
Team Actions
391(5)
Manage Links
392(1)
Manage News
393(1)
Team Development Settings
393(1)
Release Summary
394(1)
Utilities
395(1)
User Roles for Team Development
396(1)
Summary
396(1)
Chapter 16 Dynamic Actions
397(16)
Dynamic Action Benefits
397(1)
Breaking Down Dynamic Actions
397(1)
Dynamic Actions in the Help Desk Application
398(13)
Starting Simple
398(4)
Using Page-Level Events
402(2)
Dynamic Actions with Multiple Triggering Elements
404(1)
Dynamic Actions Using PL/SQL
405(2)
Dynamic Actions Using JavaScript
407(4)
Summary
411(2)
Index 413
strongDoug Gault/strong is the APEX Practice Director at Enkitec, an Oracle Platinum partner founded in 2004 which provides consulting, education, and products based around Oracle Technology. He has been working with Oracle since 1988, starting with version 5.1B, SQL*Forms 2.0, and RPT/RPF. He has focused his career on Oracle's development technologies, spending the majority of that time dedicated to web-based technologies including the OWA Web Toolkit, PL/SQL Server Pages, WebDB, Oracle Portal, and more recently HTML-DB and APEX.p p Doug's many years of Oracle experience have taken him all over the world to participate in some truly ground-breaking projects. Doug has presented at and participated in roundtable discussions at a number of conferences including Oracle OpenWorld, UKOUG, and ODTUG's APEXposed & Kaleidoscope conferences. He holds an Associate s Degree in Computer Science and an honorary Master's Degree from The School of Hard Knocks, believing there is no replacement for hard-earned experience.p p Doug is an Oracle Ace and can be found on Twitter as @dgault_apex and on his blog douggault.blogspot.com. You can contact Doug at a href="mailto:[email protected]"[email protected]/a.