Muutke küpsiste eelistusi

Beginning Oracle Application Express 4 1st ed. [Pehme köide]

3.50/5 (5 hinnangut Goodreads-ist)
, , , ,
  • Formaat: Paperback / softback, 440 pages, kõrgus x laius: 254x178 mm, kaal: 826 g, XVII, 440 p., 1 Paperback / softback
  • Ilmumisaeg: 25-Mar-2011
  • Kirjastus: APress
  • ISBN-10: 1430231475
  • ISBN-13: 9781430231479
Teised raamatud teemal:
  • Pehme köide
  • Hind: 42,17 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 49,62 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Beginning Oracle Application Express 4 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 440 pages, kõrgus x laius: 254x178 mm, kaal: 826 g, XVII, 440 p., 1 Paperback / softback
  • Ilmumisaeg: 25-Mar-2011
  • Kirjastus: APress
  • ISBN-10: 1430231475
  • ISBN-13: 9781430231479
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781430231479.html
Märksõnad:

Beginning Oracle Application Express 4 introduces one of the most talked-about development platforms to come out of Oracle Corporation in years. Oracle Application Express, called APEX for short, enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4 brings a huge leap forward in terms of functionality and usability for both the developer and the end user. 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.

Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX,Beginning Oracle Application Express 4 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. While the book assumes a foundational knowledge of SQL and PL/SQL, all code used is documented and explained so that those new to the languages will not be lost.

  • Covers brand-new functionality in APEX 4
  • Provides fully documented and explained example code
  • Guides you through creating a working and fully deployable application
Contents at a Glance iv
About the Authors xv
Acknowledgments xvil
Chapter 1 An Introduction to APEX 4
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(24)
The Anatomy of a Workspace
7(5)
APEX Users
8(1)
Applications, Pages, Regions, and Items
8(2)
Workspaces, Applications, and Schemas
10(1)
A Final Word on Workspaces
11(1)
A Tour of the APEX Modules
12(18)
The Home Page
13(2)
Application Builder
15(2)
SQL Workshop
17(13)
Administration and Team Development
30(1)
Summary
30(1)
Chapter 3 Identifying the Problem & Designing the Solution
31(8)
Identifying System Requirements
31(3)
Never a Clean Slate
31(1)
A Broken System
32(1)
How Do You Fix Things?
32(2)
System Design with APEX in Mind
34(3)
Table Definition and User Interface Defaults
35(1)
APEX and Primary Keys
35(1)
Business Logic vs. User Interface Logic
36(1)
Placement of Database Objects
36(1)
Translating Theory to Practice
37(1)
Summary
38(1)
Chapter 4 SQL Workshop
39(22)
Creating Objects with the Object Browser
39(6)
Loading Data with the Data Workshop Utility
45(5)
Creating a Lookup Table
50(3)
Loading and Running SQL Scripts
53(3)
User Interface Defaults
56(3)
Defining UI Defaults for Your Tables
56(3)
Summary
59(2)
Chapter 5 Application and Navigation
61(38)
The Create Application Wizard
61(11)
Sample Applications
62(1)
Websheet Applications
63(1)
Database Applications from Spreadsheets
64(1)
Database Applications from Scratch
65(7)
Static HTML Regions
72(2)
Public Pages
74(1)
Navigation Bar Entries
75(3)
Page Zero
78(1)
Breadcrumb Region
79(4)
Breadcrumb Entries
83(1)
Lists
84(4)
List Regions
88(4)
Template Positions
92(1)
Lists of Values
93(4)
Static List of Values
94(1)
Dynamic List of Values
95(2)
Summary
97(2)
Chapter 6 Forms and Reports - The Basics
99(56)
APEX Forms
99(2)
Form on a Table
101(10)
Creating a Form on a Table
101(4)
Modifying a Form on a Table
105(4)
Looking Behind the Scenes
109(2)
Form on a Procedure
111(4)
Creating a Form on a Procedure
111(2)
Modifying a Form on a Procedure
113(1)
Looking Behind the Scenes
114(1)
Master-Detail Report and Form
115(10)
Creating a Master-Detail Report and Form
115(4)
Modify a Master-Detail Report
119(6)
Session State
125(4)
Understanding Session State
126(1)
Sharing Database Connections
126(1)
Setting and Retrieving Session State
127(1)
Viewing Session State
127(2)
APEX Items
129(2)
Page versus Application items
129(1)
The Importance of Bind Variables
130(1)
Built In Items
130(1)
APEX URL Syntax
131(1)
Searchable APEX Reports
132(7)
Creating a Searchable APEX Report
132(4)
Looking Behind the Scenes - APEX Report
136(2)
Looking Behind the Scenes - APEX Master-Detail Forms
138(1)
More on APEX Forms
139(10)
Item Layout
140(7)
Master-Detail Cleanup
147(2)
APEX Help
149(2)
Adding a Help Text Region
149(1)
Seeding Help Text
150(1)
Declarative Blobs
151(3)
Summary
154(1)
Chapter 7 Forms and Reports - Advanced
155(52)
Tabular Forms
155(7)
Creating a Tabular Form
155(3)
Modifying a Tabular Form
158(3)
Looking Behind the Scenes
161(1)
Interactive Reports
162(30)
Creating an Interactive Report
163(2)
Running an Interactive Report
165(2)
Restricting Functionality by Report
167(1)
Restricting Functionality by Column
168(1)
Using the Column Heading Menu
168(1)
Searching by Column
169(3)
Selecting Columns
172(1)
Filtering
172(2)
Sorting
174(1)
Adding Breaks
175(1)
Highlighting
176(1)
Computing Columns
176(1)
Adding Aggregates
177(1)
Adding Charts
178(1)
Grouping
179(1)
Using Flashback
180(1)
Saving an Interactive Report
180(1)
Resetting an Interactive Report
181(1)
Getting Help
181(1)
Adding a Subscription
182(1)
Downloading
183(2)
Modifying an Interactive Report
185(6)
Looking Behind the Scenes
191(1)
Calendars
192(6)
Understanding Calendar Types
192(1)
Creating a Calendar
192(5)
Looking Behind the Scenes
197(1)
Charts
198(8)
Writing Queries for Charts
199(1)
Creating a Chart
199(5)
Looking Behind the Scenes
204(2)
Summary
206(1)
Chapter 8 Programmatic Elements
207(38)
Conditions
207(1)
Validations
207(13)
Required Values
208(1)
Item Level Validation
209(5)
Page Level Validation
214(3)
Tabular Form Validation
217(3)
Computations
220(5)
Execution
220(1)
Types
221(1)
Creating a Computation
221(4)
Processes
225(5)
Execution Points
225(1)
Process Types
226(1)
Process in the Help Desk Application
226(4)
PL/SQL Regions
230(2)
Dynamic SQL
232(6)
Dynamic Actions
238(5)
Major Parts
238(1)
Dynamic Actions in the Help Desk Application
238(5)
Summary
243(2)
Chapter 9 Security
245(28)
User Maintenance Navigation
245(4)
User Maintenance Data Entry
249(5)
Authentication
254(1)
Custom Authentication Schemes
255(4)
Conditional Security
259(1)
Access Control and Authorization
260(5)
Read-Only Items
265(2)
Data Security
267(3)
Session State Protection
270(1)
Summary
271(2)
Chapter 10 Application Deployment
273(8)
Exporting
273(2)
Importing
275(2)
Supporting Objects
277(2)
Summary
279(2)
Chapter 11 Understanding Websheets
281(32)
Websheet Structure
281(2)
Navigation
283(2)
Content Navigation
283(2)
Structural Navigation
285(1)
Help
285(2)
Markup Syntax
287(1)
User Authentication
288(2)
User Authorization
290(5)
Sections
295(16)
Text Sections
295(3)
Navigation Sections
298(1)
Data Sections
299(12)
Chart Sections
311(1)
Annotations
311(1)
Administration
312(1)
Summary
312(1)
Chapter 12 A Websheet Example
313(20)
Setup
313(1)
Creating and Configuring a Websheet Application
314(3)
Adding Content to a Websheet
317(14)
Creating Data Grids
318(4)
Adding Players
322(1)
Creating Alternate Default Reports
323(1)
Creating Page Sections
324(6)
SQL Tags
330(1)
Access Controls
331(1)
Summary
331(2)
Chapter 13 Extended Developer Tools
333(22)
Page Locks
333(3)
APEX Conflicts
334(1)
Locking an APEX Page
334(1)
Unlocking a Page
335(1)
Administering Page Locks
336(1)
Application and Page Groups
336(2)
Application Groups
337(1)
Page Groups
338(1)
APEX Views and the APEX Dictionary
338(4)
The APEX Schema
339(1)
APEX Views
339(2)
APEX Dictionary
341(1)
Searching within APEX
342(2)
APEX Finder
342(1)
Search Application
343(1)
Monitoring your APEX Application
344(3)
Enabling Logging
344(1)
Using the Activity Logs
345(1)
Login Attempts
346(1)
APEX Advisor
347(1)
Build Options
348(4)
Understanding the Need
348(1)
Creating a Build Option
349(1)
Configuring Build Options
350(1)
Prompting for Build Option Status
350(1)
Applying Build Options
351(1)
Reporting on Build Option Utilization
352(1)
Page Specific Utilities
352(1)
APEX and Oracle SQL Developer
353(1)
Integration
353(1)
Refactoring Support
354(1)
Summary
354(1)
Chapter 14 Managing Workspaces
355(20)
Learning About Your Environment
355(3)
Viewing Instance Information
356(2)
Checking the APEX Version
358(1)
Managing the Service
358(3)
Workspace Preferences
359(1)
Announcements
360(1)
Managing Meta Data
361(8)
Developer Activity and Click Count Logs
361(1)
Session State
362(1)
Application Cache
363(1)
Websheet Database Objects
363(1)
Application Build Status
364(1)
Application Models
364(2)
File Utilization
366(1)
Interactive Report Settings
367(2)
Managing Users and Groups
369(4)
Creating One User
369(1)
Creating Multiple Users
370(2)
Organizing Users Into Groups
372(1)
Viewing Usage Reports and Dashboards
373(1)
Summary
374(1)
Chapter 15 Team Development
375(30)
Team Development Overview
375(2)
Team Development Interface
377(6)
APEX Home Page
377(1)
Team Development Home Page
378(1)
Common Design Elements
379(1)
Drilldown Functionality
380(2)
Tagging
382(1)
Features
383(3)
Features Tab
383(2)
History Tab
385(1)
Progress Log Tab
386(1)
Milestones
386(3)
Milestones Tab
387(1)
Milestone Details Tab
388(1)
Features by Milestone Tab
388(1)
To Do Items
389(1)
Bugs
390(1)
Feedback
391(8)
Configuring Feedback
392(2)
Polishing the Feedback Page
394(3)
Viewing Feedback
397(1)
Responses to Feedback
398(1)
Communication Between Workspaces
398(1)
Team Actions
399(4)
Manage Links
399(1)
Manage News
400(1)
Team Development Settings
401(1)
Release Summary
401(1)
Utilities
402(1)
User Roles for Team Development
403(1)
Summary
403(2)
Index 405
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:doug.gault@enkitec.com"doug.gault@enkitec.com/a.