book

Beginning Oracle Application Express 4

Name: Beginning Oracle Application Express 4
ISBN: 9781430231479

by Doug Gault, Karen Cannell, Patrick Cimolini, Martin D'Souza, Timothy St. Hilaire

March 2011

Intermediate to advanced

439 pages

9h 17m

English

Apress

Read now

Unlock full access

Copyright
About the Authors
Acknowledgments
1. An Introduction to APEX 4
1.1. What is APEX?1.2. A Brief History of APEX1.2.1. Ancient History1.2.2. More Recent History1.2.3. APEX 4 and the Future1.3. What You Need to Get Started1.3.1. Access to an APEX Instance1.3.2. Web Browser1.3.3. SQL Developer1.4. Summary
2. A Developer's Overview
2.1. The Anatomy of a Workspace2.1.1. APEX Users2.1.2. Applications, Pages, Regions, and Items2.1.3. Workspaces, Applications, and Schemas2.1.4. A Final Word on Workspaces2.2. A Tour of the APEX Modules2.2.1. The Home Page2.2.2. Application Builder2.2.2.1. The Application Builder Home Page2.2.2.2. The Application Home Page2.2.3. SQL Workshop2.2.3.1. The Object Browser2.2.3.2. The SQL Commands Interface2.2.3.3. SQL Scripts Interface2.2.3.4. The Query Builder2.2.3.5. Utilities2.2.4. Administration and Team Development2.3. Summary
3. Identifying the Problem & Designing the Solution
3.1. Identifying System Requirements3.1.1. Never a Clean Slate3.1.2. A Broken System3.1.3. How Do You Fix Things?3.1.3.1. Defining the Requirements3.1.3.2. Extrapolating to a Database Design3.2. System Design with APEX in Mind3.2.1. Table Definition and User Interface Defaults3.2.2. APEX and Primary Keys3.2.3. Business Logic vs. User Interface Logic3.2.4. Placement of Database Objects3.3. Translating Theory to Practice3.4. Summary
4. SQL Workshop
4.1. Creating Objects with the Object Browser4.2. Loading Data with the Data Workshop Utility4.3. Creating a Lookup Table4.4. Loading and Running SQL Scripts4.5. User Interface Defaults4.5.1. Defining UI Defaults for Your Tables4.6. Summary
5. Application and Navigation
5.1. The Create Application Wizard5.1.1. Sample Applications5.1.2. Websheet Applications5.1.3. Database Applications from Spreadsheets5.1.4. Database Applications from Scratch5.1.4.1. Naming the Application5.1.4.2. Laying Out Pages5.1.4.3. Choosing an Approach to Tabs5.1.4.4. Copying Shared Components5.1.4.5. Selecting an Authentication Method5.1.4.6. Selecting a Theme5.1.4.7. Completing the Application Creation Wizard5.2. Static HTML Regions5.3. Public Pages5.4. Navigation Bar Entries5.5. Page Zero5.6. Breadcrumb Region5.7. Breadcrumb Entries5.8. Lists5.9. List Regions5.10. Template Positions5.11. Lists of Values5.11.1. Static List of Values5.11.2. Dynamic List of Values5.12. Summary
6. Forms and Reports – The Basics
6.1. APEX Forms6.2. Form on a Table6.2.1. Creating a Form on a Table6.2.2. Modifying a Form on a Table6.2.3. Looking Behind the Scenes6.3. Form on a Procedure6.3.1. Creating a Form on a Procedure6.3.2. Modifying a Form on a Procedure6.3.3. Looking Behind the Scenes6.4. Master-Detail Report and Form6.4.1. Creating a Master-Detail Report and Form6.4.2. Modify a Master-Detail Report6.5. Session State6.5.1. Understanding Session State6.5.2. Sharing Database Connections6.5.3. Setting and Retrieving Session State6.5.4. Viewing Session State6.6. APEX Items6.6.1. Page versus Application items6.6.2. The Importance of Bind Variables6.6.3. Built In Items6.7. APEX URL Syntax6.8. Searchable APEX Reports6.8.1. Creating a Searchable APEX Report6.8.2. Looking Behind the Scenes – APEX Report6.8.3. Looking Behind the Scenes – APEX Master-Detail Forms6.9. More on APEX Forms6.9.1. Item Layout6.9.2. Master-Detail Cleanup6.10. APEX Help6.10.1. Adding a Help Text Region6.10.2. Seeding Help Text6.11. Declarative Blobs6.12. Summary
7. Forms and Reports — Advanced
7.1. Tabular Forms7.1.1. Creating a Tabular Form7.1.2. Modifying a Tabular Form7.1.3. Looking Behind the Scenes7.2. Interactive Reports7.2.1. Creating an Interactive Report7.2.2. Running an Interactive Report7.2.3. Restricting Functionality by Report7.2.4. Restricting Functionality by Column7.2.5. Using the Column Heading Menu7.2.6. Searching by Column7.2.7. Selecting Columns7.2.8. Filtering7.2.9. Sorting7.2.10. Adding Breaks7.2.11. Highlighting7.2.12. Computing Columns7.2.13. Adding Aggregates7.2.14. Adding Charts7.2.15. Grouping7.2.16. Using Flashback7.2.17. Saving an Interactive Report7.2.18. Resetting an Interactive Report7.2.19. Getting Help7.2.20. Adding a Subscription7.2.21. Downloading7.2.22. Modifying an Interactive Report7.2.23. Looking Behind the Scenes7.3. Calendars7.3.1. Understanding Calendar Types7.3.2. Creating a Calendar7.3.3. Looking Behind the Scenes7.4. Charts7.4.1. Writing Queries for Charts7.4.2. Creating a Chart7.4.3. Looking Behind the Scenes7.5. Summary

8. Programmatic Elements
8.1. Conditions8.2. Validations8.2.1. Required Values8.2.2. Item Level Validation8.2.3. Page Level Validation8.2.4. Tabular Form Validation8.3. Computations8.3.1. Execution8.3.2. Types8.3.3. Creating a Computation8.4. Processes8.4.1. Execution Points8.4.2. Process Types8.4.3. Process in the Help Desk Application8.5. PL/SQL Regions8.6. Dynamic SQL8.7. Dynamic Actions8.7.1. Major Parts8.7.2. Dynamic Actions in the Help Desk Application8.8. Summary
9. Security
9.1. User Maintenance Navigation9.2. User Maintenance Data Entry9.3. Authentication9.4. Custom Authentication Schemes9.5. Conditional Security9.6. Access Control and Authorization9.7. Read-Only Items9.8. Data Security9.9. Session State Protection9.10. Summary
10. Application Deployment
10.1. Exporting10.2. Importing10.3. Supporting Objects10.4. Summary
11. Understanding Websheets
11.1. Websheet Structure11.2. Navigation11.2.1. Content Navigation11.2.2. Structural Navigation11.3. Help11.4. Markup Syntax11.5. User Authentication11.6. User Authorization11.7. Sections11.7.1. Text Sections11.7.2. Navigation Sections11.7.3. Data Sections11.7.3.1. Reports - Setup11.7.3.2. Reports - Creation11.7.3.3. Reports - Accessing the Data11.7.3.4. Data Grids11.7.4. Chart Sections11.8. Annotations11.9. Administration11.10. Summary
12. A Websheet Example
12.1. Setup12.2. Creating and Configuring a Websheet Application12.3. Adding Content to a Websheet12.3.1. Creating Data Grids12.3.1.1. Applying Constraints12.3.2. Adding Players12.3.3. Creating Alternate Default Reports12.3.4. Creating Page Sections12.3.5. SQL Tags12.4. Access Controls12.5. Summary
13. Extended Developer Tools
13.1. Page Locks13.1.1. APEX Conflicts13.1.2. Locking an APEX Page13.1.3. Unlocking a Page13.1.4. Administering Page Locks13.2. Application and Page Groups13.2.1. Application Groups13.2.2. Page Groups13.3. APEX Views and the APEX Dictionary13.3.1. The APEX Schema13.3.2. APEX Views13.3.3. APEX Dictionary13.4. Searching within APEX13.4.1. APEX Finder13.4.2. Search Application13.5. Monitoring your APEX Application13.5.1. Enabling Logging13.5.2. Using the Activity Logs13.5.3. Login Attempts13.6. APEX Advisor13.7. Build Options13.7.1. Understanding the Need13.7.2. Creating a Build Option13.7.3. Configuring Build Options13.7.4. Prompting for Build Option Status13.7.5. Applying Build Options13.7.6. Reporting on Build Option Utilization13.8. Page Specific Utilities13.9. APEX and Oracle SQL Developer13.9.1. Integration13.9.2. Refactoring Support13.10. Summary
14. Managing Workspaces
14.1. Learning About Your Environment14.1.1. Viewing Instance Information14.1.2. Checking the APEX Version14.2. Managing the Service14.2.1. Workspace Preferences14.2.2. Announcements14.3. Managing Meta Data14.3.1. Developer Activity and Click Count Logs14.3.1.1. Developer Activity Logs14.3.1.2. Click Count Logs14.3.2. Session State14.3.2.1. Manage Session State14.3.2.2. Manage Preferences14.3.3. Application Cache14.3.4. Websheet Database Objects14.3.5. Application Build Status14.3.6. Application Models14.3.7. File Utilization14.3.8. Interactive Report Settings14.3.8.1. Saved Reports14.3.8.2. Subscriptions14.4. Managing Users and Groups14.4.1. Creating One User14.4.2. Creating Multiple Users14.4.3. Organizing Users Into Groups14.4.3.1. Creating a Group14.4.3.2. Assigning Users to a Group14.5. Viewing Usage Reports and Dashboards14.6. Summary
15. Team Development
15.1. Team Development Overview15.2. Team Development Interface15.2.1. APEX Home Page15.2.2. Team Development Home Page15.2.3. Common Design Elements15.2.4. Drilldown Functionality15.2.5. Tagging15.3. Features15.3.1. Features Tab15.3.2. History Tab15.3.3. Progress Log Tab15.4. Milestones15.4.1. Milestones Tab15.4.2. Milestone Details Tab15.4.3. Features by Milestone Tab15.5. To Do Items15.6. Bugs15.7. Feedback15.7.1. Configuring Feedback15.7.2. Polishing the Feedback Page15.7.3. Viewing Feedback15.7.4. Responses to Feedback15.7.5. Communication Between Workspaces15.8. Team Actions15.8.1. Manage Links15.8.2. Manage News15.8.3. Team Development Settings15.8.4. Release Summary15.8.5. Utilities15.9. User Roles for Team Development15.10. Summary

Content preview from Beginning Oracle Application Express 4

Copyright

Beginning Oracle Application Express 4

All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.

ISBN-13 (pbk): 978-1-4302-3147-9

ISBN-13 (electronic): 978-1-4302-3148-6

Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1

Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781430231479Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Beginning Oracle Application Express 4

by Doug Gault, Karen Cannell, Patrick Cimolini, Martin D'Souza, Timothy St. Hilaire

Copyright

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.