Skip to main content
main-content

Über dieses Buch

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

Inhaltsverzeichnis

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

Weitere Informationen

Premium Partner

    Bildnachweise