Muutke küpsiste eelistusi

E-raamat: Understanding Oracle APEX 20 Application Development: Think Like an Application Express Developer

3.71/5 (14 hinnangut Goodreads-ist)
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 67,91 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Understanding Oracle APEX 20 Application Development: Think Like an Application Express DeveloperSuurem pilt
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Beginning-Intermediate user level

This book shows developers and Oracle professionals how to build practical, non-trivial web applications using Oracle’s rapid application development environment – Application Express (APEX). This third edition Is revised to cover the new features and user interface experience found in APEX 20. Interactive grids and form regions are two of the newer aspects of APEX covered in this edition. The book is targeted at those who are new to APEX and just beginning to develop real projects for deployment, as well as those who are familiar with APEX and want a deeper understanding. The book takes you through the development of a demo web application that illustrates the concepts all APEX programmers should know. 

This book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. Topics include conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and security control. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 20 Application Development, 3rd Edition is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications.


What You Will Learn
  • Build attractive, highly functional web apps from the ground up
  • Enhance and customize pages created by the APEX wizards
  • Understand the security implications of page design
  • Write PL/SQL code for process activity and verification
  • Build complex components such as forms and interactive grids

Who This Book Is For

Developers new to APEX who desire a strong fundamental understanding of how APEX applications work. For existing developers and database administrators desiring to mine the most value from APEX by improving their development techniques. 
About the Author xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction xix
Chapter 1 The SQL Workshop
1(12)
Downloading Tables
3(2)
Object Browser
5(4)
SQL Command Tool
9(3)
Summary
12(1)
Chapter 2 Applications and Pages
13(20)
Creating an Application
13(4)
Editing Application Properties
17(2)
Deleting an Application
19(1)
Running an Application
19(3)
Running a Page from Within APEX
19(3)
Running a Page from Outside APEX
22(1)
Creating a New
22(3)
Page Designer
25(3)
Property Editor
28(4)
Accessing Built-in Help
32(1)
Summary
32(1)
Chapter 3 Regions
33(68)
Creating and Deleting Regions
34(1)
Type-Independent Region Properties
35(11)
Identification and Source Sections
36(3)
Layout Section
39(6)
Appearance Section
45(1)
Drag and Drop
46(3)
Static Content Regions
49(8)
Formatted vs. Unformatted Text
50(3)
Substitution Strings
53(1)
Referring to APEX Pages
53(1)
Referring to Local Images
54(3)
Classic Report Regions
57(14)
Column-Specific Properties
60(9)
Report-Specific Properties
69(1)
Using the Source Query for Formatting
70(1)
Chart Regions
71(7)
Creating a Chart Region
73(2)
Configuring a Chart
75(1)
Configuring a Chart Series
75(3)
Multi-Series Charts
78(6)
Customizing a Chart
79(5)
Interactive Report Regions
84(14)
Using the Search Bar
86(7)
Configuring the Search Bar
93(3)
Link Column
96(2)
Summary
98(3)
Chapter 4 Navigation
101(32)
Lists
101(8)
Viewing List Details
102(1)
Editing List Entries
103(2)
Creating New List Entries
105(3)
Creating a New List
108(1)
Modifying the Navigation Interface
109(3)
Configuring the Navigation Menu
110(2)
Configuring the Navigation Bar
112(1)
List Regions
112(4)
Hierarchical Lists
116(6)
Mega Menus
122(1)
Page Hierarchy
123(2)
Breadcrumbs
125(4)
Breadcrumb Regions
129(1)
Global
130(1)
Summary
130(3)
Chapter 5 Items and Buttons
133(34)
Items
133(1)
Item Sampler
134(3)
Creating and Deleting Items
137(4)
Positioning an Item
141(1)
Text-Based Items
142(8)
Text Fields
143(1)
Number Fields
143(1)
Password Items
143(1)
Text Fields with Autocomplete
143(3)
Color Pickers
146(1)
Date Pickers
146(2)
Properties of All Text-Based Items
148(2)
List-Based Items
150(5)
Dynamic List-Based Items
152(2)
Static List-Based Items
154(1)
Multi-Value List Items
155(3)
Yes/No Items
158(2)
Display-Based Items
160(1)
Initial Item Values
160(2)
Buttons
162(4)
Summary
166(1)
Chapter 6 Session State
167(30)
Session IDs
167(1)
Submit vs. Redirect
168(1)
Using an Item to Submit a
169(2)
Redirect Can Set Session State
171(1)
Referring to Session State Variables
172(1)
Customized Reports
173(6)
Filter by Job and Department
173(2)
Filter by Possible Department
175(3)
Filter by Salary Range
178(1)
Master-Detail Reports
179(3)
Chart Drill Down
182(3)
Customized Titles and Labels
185(2)
Cascading Lists
187(3)
Conditional Rendering
190(3)
Region Display Selectors
193(2)
Summary
195(2)
Chapter 7 Processes
197(50)
Stages of a Submit Action
197(1)
Creating a Process
198(2)
PI/SQL to Access the Database
200(6)
Delete Employee Region
202(1)
Insert Employee Region
203(1)
Update Employee Region
204(2)
PL/SQL to Compute Values
206(5)
Local Variables
210(1)
Comments
210(1)
Assignment Statements
210(1)
Conditional Statements
210(1)
Handling Multi-Row SQL Queries
211(3)
Concurrent Database Updates
214(8)
Lost Update Problem
214(2)
Avoiding Lost Updates
216(4)
Using a Hash Function
220(2)
Success and Error Messages
222(2)
Conditional Processes
224(5)
Submitting via Items
224(2)
Multiple-Use Processes
226(3)
Page Rendering Processes
229(10)
Executing a Process Without a Submit
231(4)
Moving Between Regions
235(1)
Finding Previous and Next Rows
235(4)
Single Row Update
239(6)
Implementing the Report Region
241(1)
Implementing the Insert Region
241(1)
Implementing the Update/Delete Region
242(3)
Summary
245(2)
Chapter 8 Data Validation
247(16)
Constraint Preservation
247(5)
Input Validation
252(7)
Constraint Validations
259(1)
Process Validation
260(1)
Summary
261(2)
Chapter 9 Branches
263(18)
Separating Input from Output
263(3)
Creating a Branch
266(2)
Conditional Branching
268(1)
Wizard-Like Interfaces
269(11)
Implementing the Progress Bar
272(2)
Basic Info
274(3)
Manager Info
277(1)
Hiredate Info
278(1)
Confirm Employee Info
278(2)
Summary
280(1)
Chapter 10 Forms
281(46)
Form Regions
281(7)
Form Update
288(10)
Updating Records
289(4)
Clearing Session State
293(2)
Inserting Records
295(3)
Computations
298(2)
Sending Email
300(2)
Report with Form Pages
302(11)
The Report
309(1)
The Form
310(2)
Customizing the Report and Form
312(1)
Form Pages
313(5)
Implementing the Tree
315(1)
Implementing the Form
316(2)
Master-Detail Forms
318(8)
Summary
326(1)
Chapter 11 Interactive Grids
327(22)
Read-Only Interactive Grids
327(4)
Editing Interactive Grids
331(6)
Ensuring Consistency
337(6)
Grid Validations
338(2)
Restricting Interactive Grid Input
340(3)
Grid Processes
343(5)
Summary
348(1)
Chapter 12 Dynamic SQL
349(18)
Dynamic Reports
349(6)
Dynamic Processes
355(6)
Combining Dynamic Reports and Processes
361(4)
Summary
365(2)
Chapter 13 Security
367(46)
Authentication
367(11)
Managing Authentication Schemes
368(4)
Writing an Authentication Function
372(5)
Public Pages
377(1)
Authorization
378(9)
Creating an Authorization Scheme
378(5)
Component Authorization
383(1)
Page Authorization
384(2)
Not Public User Scheme
386(1)
Avoiding Malicious Use
387(24)
SQL Injection
387(8)
Cross-Site Scripting
395(8)
URL Modification
403(8)
Summary
411(2)
Index 413
Edward Sciore is a recently retired Associate Professor in the computer science department at Boston College. He has been teaching college students for more than 35 years. His research specialty is database systems, and he thoroughly enjoys teaching the wonders of database technology to captive students.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842616516e.html