Beginning Oracle. Application Express 4. Doug Gault. Timothy St. Hilaire. Karen Cannell. Martin D'Souza. Patrick Cimolini

11 

Full text

(1)

Beginning

Oracle

Application

Express

4

Doug

Gault

Karen Cannell

Patrick

Cimolini

Martin D'Souza

Timothy

St. Hilaire

(2)

Contentsata Glance iv

Aboutthe Authors xv

Acknowledgments

xvil

0

Chapter

1: An Introduction to APEX 4 1

What is APEX?.... 1

A Brief

History

of APEX 2

AncientHistory 2 More RecentHistory 2 APEX 4 and the Future 3

WhatYou Need to Get Started 4

Accessto an APEX Instance 4

Web Browser 5

SQLDeveloper 5

Summary 5

BChapter

2: A

Developer's

Overview 7

The

Anatomy

ofa

Workspace

7

APEXUsers 8

Applications,Pages, Regions,and Items 8

Workspaces, Applications,and Schemas 10

AFinal WordonWorkspaces 11

A Tour of the APEX Modules 12

The HomePage 13

(3)

SQLWorkshop

Administration and Team Development

Summary

Chapter

3:

Identifying

the Problem &

Designing

the Solution

Identifying

System

Requirements

NeveraClean Slate

A BrokenSystem How Do You FixThings?

System Design

with APEX in Mind

Table Definitionand UserInterface Defaults APEX andPrimaryKeys

BusinessLogicvs.User InterfaceLogic

Placement of DatabaseObjects

Translating Theory

to Practice

Summary

j

Chapter

4: SQL

Workshop

Creating Objects

with the

Object

Browser

Loading

Data with the Data

Workshop Utility

Creating

a

Lookup

Table

Loading

and

Running

SQL

Scripts

User Interface Defaults

DefiningUl Defaults for Your Tables

Summary

Chapter

5:

Application

and

Navigation

The Create

Application

Wizard

Sample Applications

WebsheetApplications

DatabaseApplicationsfromSpreadsheets DatabaseApplicationsfromScratch

(4)

Static HTML

Regions

72

Public

Pages

, 74

Navigation

BarEntries 75

PageZero 78 Breadcrumb

Region

79 Breadcrumb Entries ...83 Lists 84 List

Regions

88

Template

Positions 92 Lists of Values 93

StaticListof Values 94

DynamicList of Values 95

Summary

97

m

Chapter

6: Forms and

Reports

-The Basics 99

APEX Forms 99

Form on aTable 101

CreatingaFormon aTable 101

Modifyinga Formon aTable 105

Looking Behindthe Scenes 109

Formon a Procedure ....111

CreatingaFormon aProcedure 111

ModifyingaForm on aProcedure 113

LookingBehind theScenes 114

Master-Detail

Report

and Form 115

CreatingaMaster-DetailReportand Form 115

ModifyaMaster-DetailReport 119

Session State 125

UnderstandingSessionState 126

Sharing Database Connections 126

(5)

ViewingSession State 127

APEX Items 129

PageversusApplicationitems 129

The Importanceof BindVariables 130

BuiltInItems 130

APEX URL

Syntax

131

Searchable APEX

Reports

132

CreatingaSearchable APEXReport 132

Looking Behind the Scenes-APEX

Report 136

Looking Behind the Scenes-APEX Master-Detail Forms 138

More onAPEX Forms 139

ItemLayout 140

Master-DetailCleanup 147

APEX

Help

149

AddingaHelpTextRegion 149

Seeding HelpText 150

Declarative Blobs 151

Summary

154

Chapter

7: Forms and

Reports

-Advanced 155

Tabular Forms 155

CreatingaTabular Form 155

ModifyingaTabularForm 158

LookingBehind theScenes 161

Interactive

Reports

162

CreatinganInteractiveReport 163

RunninganInteractive Report 165

Restricting Functionality by Report 167

Restricting Functionality byColumn 168

Usingthe Column HeadingMenu 168

Searching by Column 169

(6)

Filtering 172 Sorting 174 AddingBreaks , 175 Highlighting 176 ComputingColumns 176 AddingAggregates 177 AddingCharts 178 Grouping 179 UsingFlashback 180

Saving an InteractiveReport 180

ResettinganInteractiveReport 181

Getting Help 181

AddingaSubscription 182

Downloading 183

ModifyinganInteractive Report 185

LookingBehind the Scenes 191

Calendars 192

Understanding CalendarTypes 192

Creating aCalendar 192

Looking BehindtheScenes 197

Charts 198

WritingQueriesfor Charts 199

CreatingaChart 199

Looking Behind the Scenes 204

Summary

206

Chapter

8:

Programmatic

Elements 207

Conditions 207

Validations 207

RequiredValues 208

Item Level Validation 209

PageLevelValidation 214 TabularFormValidation 217

(7)

Computations

220 Execution 220 Creatinga Computation 221 Processes.... 225 ExecutionPoints 225 ProcessTypes 226 Process in theHelpDeskApplication 226

PI/SQL

Regions

,. ,.230

Dynamic

SQL ...,...*...232

Dynamic

Actions 238

MajorParts 238

DynamicActions in theHelp DeskApplication 238

Summary

, 243

Ctisipt&r

9#

SvB'Curity

*»*«f***##**t«*»•**•*************•••**!» 1**1 j)**!*•«*•«*«<**245

UserMaintenance

Navigation

245

User Maintenance Data

Entry

249

Authentication 254

Custom Authentication Schemes 255

Conditional

Security

259

Access Control and Authorization 260

Read-Oniy

Items ..265

Data

Security

267

Session

State Protection 270

Summary

**.•*...,*... ..*...»..*,..*...*..»».**....»..*•**..*.*.*..»*«.*.»».»».«*»»»»..*« 271

§

Chapter

10:

Application Deployment...

273

Exporting..

273

Importing...

... 275

(8)

Summary

279

IlChapter

11:

Understanding

Websheets ,,...281

Websheet Structure , 281

Navigation

283 ContentNavigation 283 Structural Navigation 285

Help

285

Markup

Syntax

287 UserAuthentication 288 User

Authorization

290 Sections 295 Text Sections 295 NavigationSections 298 Data Sections 299 Chart Sections 311 Annotations , 311 Administration 312

Summary

312

mChapter

12; A Websheet

Example

313

Setup

313

Creating

and

Configuring

aWebsheet

Application

314

Adding

Content toaWebsheet.,. 317

CreatingData Grids 318

AddingPlayers 322

CreatingAlternate DefaultReports 323

Creating PageSections 324

SQLTags 330

Access Controls 331

(9)

II

Chapter

13: Extended

Developer

Tools.... 333

Page

Locks 333

APEX Conflicts 334

LockinganAPEXPage 334

UnlockingaPage 335

Administering PageLocks 336

Application

and

Page Groups

336

ApplicationGroups 337

Page Groups 338

APEX Views and the APEX

Dictionary

338

The APEX Schema 339

APEX Views. 339

APEX Dictionary 341

Searching

within APEX 342

APEX Finder 342

SearchApplication 343

Monitoring

your APEX

Application

344

Enabling Logging 344

UsingtheActivity Logs... 345

Login Attempts 346

APEX Advisor... 347

Build

Options

348

Understandingthe Need 348

CreatingaBuild Option 349

Configuring BuildOptions 350

Promptingfor BuildOption Status 350

ApplyingBuild Options 351

ReportingonBuildOptionUtilization 352

Page Specific

Utilities 352

APEX and Oracle SQL

Developer

353

Integration 353

(10)

Summary

, 354

.

Chapter

14:

Managing

Workspaces

...355

Learning

AboutYourEnvironment 355

ViewingInstance Information ,356

Checkingthe APEXVersion 358

Managing

the Service 358

WorkspacePreferences 359

Announcements 360

Managing

Meta Data 361

Developer Activityand Click CountLogs 361

Session State 362

ApplicationCache 363

Websheet DatabaseObjects 363

ApplicationBuild Status 364

Application Models 364

File Utilization 366 InteractiveReport Settings 367

Managing

Users and

Groups

369

CreatingOne User 369

CreatingMultipleUsers 370

Organizing Users Into Groups 372

Viewing Usage Reports

and Dashboards 373

Summary

374

Chapter

15: Team

Development...

...375

Team

Development

Overview 375

Team

Development

Interface 377

APEXHome Page 377

TeamDevelopmentHomePage 378

CommonDesign Elements 379

Drilldown Functionality 380

(11)

Features 383

Features Tab 383

HistoryTab 385

ProgressLogTab 386

Milestones 386

Milestones Tab 387

Milestone DetailsTab 388 Featuresby Milestone Tab 388

To Do Items 389

Bugs

390

Feedback 391

ConfiguringFeedback 392

Polishingthe FeedbackPage 394

Viewing Feedback 397

Responsesto Feedback 398

Communication BetweenWorkspaces 398

Team Actions 399

ManageLinks 399

ManageNews 400

Team Development Settings 401

ReleaseSummary 401

Utilities 402

User Roles for Team

Development

403

Summary

403

Figure

Updating...

References

Updating...

Related subjects :