book

Oracle Application Express 4 Recipes

Name: Oracle Application Express 4 Recipes
Author: Edmund Zehoo
ISBN: 9781430235064

by Edmund Zehoo

June 2011

Intermediate to advanced

354 pages

5h 26m

English

Apress

Read now

Unlock full access

Copyright
About the Author
About the Technical Reviewer
Acknowledgments
1. Introducing Oracle APEX
1.1. Deciding Whether to Use APEX1.1.1. Problem1.1.2. Solution1.1.3. How It Works1.2. Identifying an APEX Deployment Model1.2.1. Problem1.2.2. Solution1.2.3. How It Works1.3. Installing Oracle APEX1.3.1. Problem1.3.2. Solution1.3.3. How It Works1.4. Familiarizing Yourself with APEX-speak1.4.1. Problem1.4.2. Solution1.4.3. How It Works1.5. Setting up a Workspace for Team-based Development1.5.1. Problem1.5.2. Solution1.5.3. How It Works1.6. Managing the Development Process1.6.1. Problem1.6.2. Solution1.6.3. How It Works
2. Application Data Entry
2.1. Creating a Database Application2.1.1. Problem2.1.2. Solution2.1.2.1. Creating the Customers Table2.1.2.2. Creating the Database Application and Data Entry Form2.1.3. How It Works2.2. Creating a Report to Manage Your Data2.2.1. Problem2.2.2. Solution2.2.3. How It Works2.3. Changing Field Item Types in a Form2.3.1. Problem2.3.2. Solution2.3.3. How It Works2.4. Selecting from a List of Values in a Form2.4.1. Problem2.4.2. Solution2.4.3. How It Works2.5. Uploading and Downloading Files in a Form2.5.1. Problem2.5.2. Solution2.5.3. How It Works2.6. Using Tabular Forms to Speed Up Data Entry2.6.1. Problem2.6.2. Solution2.6.3. How It Works2.7. Creating a Websheet Application2.7.1. Problem2.7.2. Solution2.7.3. How It Works2.8. Changing the Item Type of a Websheet Column2.8.1. Problem2.8.2. Solution2.8.3. How It Works2.9. Modifying Values in a Websheet in Bulk2.9.1. Problem2.9.2. Solution2.9.3. How It Works
3. Wiring up Application Logic
3.1. Adding Server-side Validation to Your Form3.1.1. Problem3.1.2. Solution3.1.2.1. Setting up the Sample Objects3.1.2.2. Adding Server-side Validation3.1.3. How It Works3.2. Adding Server-side Validation to Your Tabular Form3.2.1. Problem3.2.2. Solution3.2.3. How It Works3.3. Adding Client-side JavaScript Validation to Your Form3.3.1. Problem3.3.2. Solution3.3.3. How It Works3.4. Changing the List of Items in a Drop-down List Dynamically3.4.1. Problem3.4.2. Solution3.4.2.1. Setting up the Sample Objects3.4.2.2. Creating the Cascading Relationship3.4.3. How It Works3.5. Disabling or Hiding a Section of a Form Dynamically3.5.1. Problem3.5.2. Solution3.5.3. How It Works3.6. Storing Computed Values3.6.1. Problem3.6.2. Solution3.6.3. How It Works3.7. Interacting with a Web Service3.7.1. Problem3.7.2. Solution3.7.2.1. Creating the Sample Form3.7.2.2. Adding the Web Service Reference3.7.2.3. Calling the Web Service from Your Form3.7.3. How It Works3.8. Running a PL/SQL Process when Saving the Page3.8.1. Problem3.8.2. Solution3.8.3. How It Works3.9. Sending an E-mail from the Form3.9.1. Problem3.9.2. Solution3.9.2.1. Creating the Sample Object3.9.2.2. Sending the E-mail3.9.3. How It Works
4. Customizing Look and Feel
4.1. Adding an Image Header to Your Form4.1.1. Problem4.1.2. Solution4.1.3. How It Works4.2. Adding Custom CSS Styles to Your Page4.2.1. Problem4.2.2. Solution4.2.3. How It Works4.3. Using a Custom CSS File4.3.1. Problem4.3.2. Solution4.3.3. How It Works4.4. Creating a New Theme in Your Application4.4.1. Problem4.4.2. Solution4.4.2.1. Creating a New Theme4.4.2.2. Switching the Application Theme4.4.3. How It Works4.5. Modifying Form Control Templates4.5.1. Problem4.5.2. Solution4.5.3. How It Works4.6. Creating Reusable Code Snippets4.6.1. Problem4.6.2. Solution4.6.3. How It Works4.7. Extending the UI via Plug-ins4.7.1. Problem4.7.2. Solution4.7.2.1. Creating the Plug-in4.7.2.2. Using the Plug-in4.7.3. How It Works
5. Visualizing Your Data
5.1. Creating a Classic Report5.1.1. Problem5.1.2. Solution5.1.2.1. Step 1: Creating the Sample Objects5.1.2.2. Step 2: Creating the Report5.1.3. How It Works5.2. Creating Parameterized Reports5.2.1. Problem5.2.2. Solution5.2.3. How It Works5.3. Visualizing Data in Graphical Charts5.3.1. Problem5.3.2. Solution5.3.3. How It Works5.4. Visualizing Data in a Multi-Series Chart5.4.1. Problem5.4.2. Solution5.4.3. How It Works5.5. Visualizing Data on a Calendar5.5.1. Problem5.5.2. Solution5.5.3. How It Works5.6. Visualizing Data on a Map5.6.1. Problem5.6.2. Solution5.6.3. How It Works5.7. Putting it all Together into a Dashboard Page5.7.1. Problem5.7.2. Solution5.7.3. How It Works
6. Globalizing the Application
6.1. Setting up for Double-Byte Character Input6.1.1. Problem6.1.2. Solution6.1.3. How It Works6.2. Supporting Double-Byte Data Entry6.2.1. Problem6.2.2. Solution6.2.2.1. Step 1: Creating the Sample Objects6.2.2.2. Step 2: Creating and Running the Application6.2.3. How It Works6.3. Translating Your User Interface Into Another Language6.3.1. Problem6.3.2. Solution6.3.2.1. Step 1: Set Globalization Attributes6.3.2.2. Mapping to a Translated Application6.3.2.3. Step 3: Export the XLIFF File6.3.2.4. Step 4: Translate the XLIFF file6.3.2.5. Step 5: Import the Translated XLIFF File6.3.2.6. Step 6: Publish the Translated Application6.3.2.7. Step 7: Test the Translated Application6.3.3. How It Works6.4. Storing and Displaying Dates with Time Zone Information6.4.1. Problem6.4.2. Solution6.4.3. How It Works

7. Improving Application Performance
7.1. Measuring Page Access Frequency7.1.1. Problem7.1.2. Solution7.1.3. How It Works7.2. Measuring Page Performance in APEX7.2.1. Problem7.2.2. Solution7.2.3. How It Works7.3. Measuring Region Performance in APEX7.3.1. Problem7.3.2. Solution7.3.3. How It Works7.4. Enabling Region Caching7.4.1. Problem7.4.2. Solution7.4.3. How It Works7.5. Enabling Page Caching7.5.1. Problem7.5.2. Solution7.5.3. How It Works
8. Securing an Application
8.1. Creating Your Own Authentication Scheme8.1.1. Problem8.1.2. Solution8.1.3. How It Works8.2. Defining User Access Rights8.2.1. Problem8.2.2. Solution8.2.3. How It Works8.3. Preventing SQL Injection Attacks8.3.1. Problem8.3.2. Solution8.3.3. How It Works8.4. Preventing Cross-Site Scripting (XSS) Attacks8.4.1. Problem8.4.2. Solution8.4.3. How It Works
9. Deploying the Application
9.1. Deciding on a Deployment Approach9.1.1. Problem9.1.2. Solution9.1.3. How It Works9.2. Generating a List of Application Dependencies9.2.1. Problem9.2.2. Solution9.2.3. How It Works9.3. Exporting an Application9.3.1. Problem9.3.2. Solution9.3.3. How It Works9.4. Importing an Application9.4.1. Problem9.4.2. Solution9.4.3. How It Works9.5. Scripting an Application Import9.5.1. Problem9.5.2. Solution9.5.3. How It Works9.6. Exporting a Single Page9.6.1. Problem9.6.2. Solution9.6.3. How It Works9.7. Importing a Single Page9.7.1. Problem9.7.2. Solution9.7.3. How It Works9.8. Publishing the Application URL9.8.1. Problem9.8.2. Solution9.8.3. How It Works
10. A Mini Book Catalog Site
10.1. Setting Up the Main Objects for Your Book Catalog10.1.1. Problem10.1.2. Solution10.1.3. How It Works10.2. Creating the Pages to Manage the List of Books10.2.1. Problem10.2.2. Solution10.2.3. How It Works10.3. Setting Up the Book Catalog Front End10.3.1. Problem10.3.2. Solution10.3.3. How It Works10.4. Changing the Home Page of the Application10.4.1. Problem10.4.2. Solution10.4.3. How It Works10.5. Creating the Stockcount Report for the Storekeeper10.5.1. Problem10.5.2. Solution10.5.3. How It Works10.6. Setting Up the Central Administration Page10.6.1. Problem10.6.2. Solution10.6.3. How It Works10.7. Creating Tabs in Your Application10.7.1. Problem10.7.2. Solution10.7.3. How It Works

Overview

Oracle Application Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application development platform included with every Oracle Database license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction.

The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create data entry screens, visualize data in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy, problem/solution format from which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges.

Teaches Application Express via an example-based format
Takes you from beginner to intermediate level
Shows how to build a fully-functional web store in just one hour

What you'll learn

Create web application forms and tables
Customize application look and feel
Visualize data via reports, calendars, maps, and charts
Globalize applications in support of language and regional differences
Implement complex business logic
Optimize the performance of Application Express
Protect applications from security threats

Who this book is for

Oracle Application Express 4 Recipes is aimed at web application developers, PL/SQL developers, and database administrators wishing to learn and use Oracle's groundbreaking tool for rapid development—Application Express. The book is a quick-study and is perfect for the reader who wants only a good example to work from, customize, and adapt.

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: 9781430235064Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills