Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Brian Spendolini, Arie Geller
Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX
Cover
Title Page
Copyright Page
Dedication
Contents
Acknowledgments
Introduction
1 Introduction to Oracle Application Express
A Native Web Tool for Developing Web Applications
Native to the Web World
Client-Side Platform Independent
Effortless Deployment to Clients
A Declarative RAD IDE
Oracle Database Data-Centric Applications Tool
Oracle Database Tool
Data-Centric Applications
APEX Architecture
The APEX Engine
Everything in Between
Installation, Configuration, and Upgrade
The Installation Process
APEX Upgrade
Summary
2 Getting Ready
Recommended Prerequisite Knowledge
SQL and PL/SQL
HTML/HTML5, CSS, and JavaScript
jQuery
Ajax
Application Planning
High Level Design
Best Practice: Document Your Work
The Book Demo Application: Contacts in the Cloud
Application Business Logic and QA Scenarios
Designing the Data Structures
Data Modeling
Summary
3 APEX IDE: Quick Tour and Basic Concepts
Working with the APEX IDE
Main Menu
Developer Navigation Tools
Other Elements on the Workspace Home Page
Major Modules of the APEX IDE
App Builder Module
SQL Workshop Module
Team Development Module
Packaged Apps Module
Instance Administration Module
Summary
4 APEX Applications: Concepts and Building Blocks
The APEX Instance
The APEX Workspace
Workspace Users
APEX Applications
Desktop Applications
Mobile Applications
Application-Level Features and Shared Components
Websheet Applications
APEX Themes (Concepts)
APEX Themes: Evolution and Revolution
APEX Templates
APEX Pages
APEX Page Types
APEX Page Mode
APEX Regions
APEX Items
APEX Application Items
APEX Page Items
APEX Buttons
Button Properties
Summary
5 The Page Designer
Installing the Sample Database Application
Navigating the New Page Designer
The Toolbar
The Three Panes
Laying Out Items on a Page
Layout Properties
Keyboard Shortcuts
Summary
6 APEX Wizards
The Application Wizard
The Report Region
The Form Wizard
Form Wizard Review
Customizing a Report
Testing the Report Link
Creating a Button
Creating a Contact Record
Creating Interactive Reports
Column Headings
Reports Toolbar
Behind the Interactive Report Properties
Behind the Interactive Report Columns
Interactive Grids
Create an Interactive Grid
The Interactive Grid Toolbar
Row Actions Menu
Edit and Save Buttons
Other Features of Interactive Grids
Editing Data with the Interactive Grid
Interactive Grid Validations
Advanced Interactive Grid Options
Allowed Row Operations Column
Master Detail Form and User Interface Defaults
Creating a Master Detail Form
User Interface Defaults for a Table
Summary
7 Computations, Validations, Processes, and Branches
Computations
Computation Types
Page Execution Points
Creating a Computation
Validations
Item-Level Validation
Page-Level Validation
Interactive Grid Validations
Processes
Process Types
Working with Processes
Branches
Branch Execution Points
Branch Types
Creating Branches
Summary
8 Crafting a Powerful UI
Themes and Templates
User Interface Attributes
Themes
Templates
Using the Universal Theme in Your Application
Pages
Regions
Lists
Reports
Buttons
Forms
Calendars
Theme Roller
Live Template Options
Summary
9 Dynamic Actions
About Dynamic Actions
Benefits of Dynamic Actions
Getting Started
Bind Events
Actions
Anatomy of a Dynamic Action
Creating a Dynamic Action
Simple Show/Hide
Dynamic Actions Affecting Multiple Items
Dynamic Actions Using PL/SQL
Advanced Dynamic Actions—Putting It All Together
Summary
10 APEX Security
Application Attack Points
Instance-Level Security
Security Section
HTTP Protocol Section
Session Timeout Section
Workspace Isolation Section
Region and Web Service Excluded Domains Section
Authentication Control Section
Password Policy Section
REST Administration Interface Section
Workspace-Level Security
Workspace Groups
Managing Workspace Users
Application-Level Security
Application-Level Authentication and Authorization Sections
Application Session
Session State Protection Section
Browser Security Section
Page-Level Security
Security Properties
Advanced Properties
Server Cache Properties
Region and Item-Level Security
Regions Properties
Items Properties
Conditional Statements
Authentication Schemes
Authorization Schemes
Access Control
Security in Action
Authorization Schemes
Session State Protection and Item Encryption
Conditions
Application Context and Views
Security Reporting
Summary
11 Packaging and Deployment
Packaging Overview
Packaged Applications
Application Exports
Copy Your Application in the Same Workspace
Move to a New Workspace that Uses the Same or a Different Schema
Application Import/Export Strategies
Exporting Components
Importing an Application or Component
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Oracle Application Express (APEX): Build Powerful Data-Centric Web Apps with APEX
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset