Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top

2011 | Book

Introducing Oracle APEX Read chapter Read first chapter

Oracle Application Express 4 Recipes

Author: Edmund Zehoo

Publisher: Apress

Part of: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Login to get access
insite
SEARCH

About this book

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, 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

Table of Contents

Frontmatter
Chapter 1. Introducing Oracle APEX
Abstract
I still remember deploying my first Microsoft Access application 10 years ago for a head hunting agency. They had a user base of about 200 users (I can already hear some of you groan) and they needed a system to manage job applicants and the companies that want to hire them. And they tossed my meager development team of two an “uncompromisable” deadline of one month in which to conceptualize, develop, and test the system—and have it go live right after that.
Edmund Zehoo
Chapter 2. Application Data Entry
Abstract
Most business database-centric applications generally function in the same manner. An application is built around a table, say a Customer table. An end user needs to add new data to this table (in this case, a new customer record). He or she also needs to modify existing data and delete customer records from this table. Data records in this table usually take the appearance of a grid, accompanied by the New, Edit, and Delete buttons that allow the end user to modify the grid’s contents. The New and Edit buttons typically take the user to a separate detail page—a form—that displays the set of fields in a more streamlined manner for data entry.
Edmund Zehoo
Chapter 3. Wiring up Application Logic
Abstract
If you are an ASP.NET developer, you’re probably familiar with the codebehind model introduced by Microsoft to separate the presentation from the logic layer. In a codebehind page, execution of code is event-based. You specify blocks of code to execute when a page loads or when a button is clicked.
Edmund Zehoo
Chapter 4. Customizing Look and Feel
Abstract
Customizing application look and feel is one of the most important aspects of solution delivery. It is the process that defines how your application is presented to the end user. APEX is extremely flexible in this area, letting you customize not just the color schemes, headers and footers of a page, but even the attributes for the controls it uses on your form.
Edmund Zehoo
Chapter 5. Visualizing Your Data
Abstract
One of the key areas in which APEX really shines is its ability to create many different views to visualize the data in your database. If you have at least one numerical field in your table, you can massage your data to create vivid pie, doughnut, bar or candlestick charts that are either static or animated. If you have at least one date or time field in your table, you can magically populate your records on a calendar using that field. If you have a bunch of sales data, you can display it on top of each country on a beautiful high resolution map.
Edmund Zehoo
Chapter 6. Globalizing the Application
Abstract
I am sure there has been at least one occasion when you’ve taken a flight to a foreign country, proudly presented your painstakingly crafted application consisting of hundreds of web pages and a beautiful UI, only to be asked if everything could be in Thai. No? You’ve been lucky!
Edmund Zehoo
Chapter 7. Improving Application Performance
Abstract
Performance has always been a big issue when it comes to Rapid Application Development (RAD). Most developers generally share the same opinion: if it’s that fast and easy to create an application, the developer will have to “pay the price” elsewhere in terms of tool flexibility or application performance.
Edmund Zehoo
Chapter 8. Securing an Application
Abstract
Applications that you build on top of APEX are not, by default, magically hacker-proof. Even tight platforms such as APEX have several security concerns. In APEX, these concerns usually center around three main areas: authentication, authorization, and vulnerability exploits.
Edmund Zehoo
Chapter 9. Deploying the Application
Abstract
The last mile in getting your application into the hands of your intended audience is the deployment process. In traditional programming, a programmer would typically compile an application into an executable file and then package it into an automated installer for distribution.
Edmund Zehoo
Chapter 10. A Mini Book Catalog Site
Abstract
In this last chapter you will explore a real-life scenario of an online book catalog and how to apply APEX to create it in a matter of hours. Think of this catalog as the bare beginnings of a bookstore—you aren’t even going to implement anything like shopping-cart functionality but you will use the various APEX techniques and features you learned throughout the earlier chapters in the book.
Edmund Zehoo
Backmatter
Metadata
Title
Oracle Application Express 4 Recipes
Author
Edmund Zehoo
Copyright Year
2011
Publisher
Apress
Electronic ISBN
978-1-4302-3507-1
Print ISBN
978-1-4302-3506-4
DOI
https://doi.org/10.1007/978-1-4302-3507-1

Premium Partner

    Image Credits