CDN$ 5.98
  • List Price: CDN$ 69.87
  • You Save: CDN$ 63.89 (91%)
FREE Shipping on orders over CDN$ 25.
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Beginning Oracle Applicat... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Beginning Oracle Application Express 4 Paperback – Apr 18 2011

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 5.98
CDN$ 5.98 CDN$ 0.01

There is a newer edition of this item:

Beginning Oracle Application Express 4.2
CDN$ 69.32
Temporarily out of stock.

Save an Additional 10% on Textbooks When you Join Amazon Student

Special Offers and Product Promotions

  • Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Product Details

  • Paperback: 440 pages
  • Publisher: Apress; 1st ed. 2011 edition (April 18 2011)
  • Language: English
  • ISBN-10: 1430231475
  • ISBN-13: 978-1430231479
  • Product Dimensions: 19.1 x 2.5 x 23.5 cm
  • Shipping Weight: 1.1 Kg
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #828,392 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

About the Author

Doug Gault is director and co-founder of Sumneva, a world-class Oracle Application Express (APEX) consulting, training & solutions firm founded in 2010. He has been working with Oracle since 1988 starting with version 5.1B, SQL*Forms 2.0, and RPT/RPF. Since then, he has focused his career on Oracle's development technologies, spending the last decade on web based technologies, and the last six years specifically on APEX. Prior to co-founding Sumneva, Gault was vice president of Sumner Technologies, which also focused on Oracle APEX consulting, training & solutions. Before that, he served as product development director for Hotsos Enterprises, during which time he was the lead architect/developer and product manager for two commercial products written exclusively in APEX. His 21 years of Oracle experience have taken him all over the world and involved him in some truly groundbreaking projects. Gault has presented and participated in round table discussions at a number of conferences, including Oracle OpenWorld, UKOUG and ODTUG's APEXposed. He holds an associate's degree in computer science, and an honorary master's degree from the School of Hard Knocks, believing there is no replacement for hard-earned, real-world experience.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) HASH(0xa147d354) out of 5 stars 11 reviews
7 of 7 people found the following review helpful
HASH(0xa1499e04) out of 5 stars Worst Development book ever written Nov. 11 2011
By hale - Published on
Format: Paperback Verified Purchase
If you are new to APEX and truly are a beginner, do NOT purchase this book. Errors exist in every chapter. When you are redirected back to a chapter, it is the wrong chapter, wrong page. When you are told to modify a page the wrong page is cited. The download files are incorrect for this version (APEX 4). The page layout forms to do not match the APEX layouts. ERATA is non helpful except to point out the errors that a good tech writer should have found. I have never written a book review before but felt this was necessary as this book is such a disappointment. Not only should the authors be ashammed but APPRES as well for publishing this book. Would not recommend!!!
4 of 4 people found the following review helpful
HASH(0xa149b06c) out of 5 stars Book review April 6 2011
By Iloon Ellen-Wolff - Published on
Format: Paperback
If you are thinking about developing a product with Application Express this book is a great place to start. It is a complete hands-on book. You will work through the examples and exercises. Example code is available at the website from the publisher. ([...]) Downloadable code and exercises make the book very valuable for learning Application Express. It is really practical and covering almost all the essential application development aspects. You will learn Step by Step from this book with little knowledge of PL/SQL, HTML and JavaScript.

A ticket system for a help desk is created from scratch. In every chapter of the book, a part of the help system is built.
The book starts by making a description of the requirements of the help desk system and to create a database design. This book also covers the steps of creating an entity relationship diagram. Good database design is the key to creating a successful application, especially with Application Express in mind. The necessary database tables used in the ERD are created in Sql*workshop. Sql*workshop and not the ERD tool is used because the objects are created from scratch.
With the basic data created, a shell is generated for the ticket system. This will be done with the options available in Application Express. After the shell is created for the application, the application is extended with forms, reports, and charts. The strength of this book is that the theoretical part is completely integrated in the exercises. This makes the book even more valuable.
When the basic part of the application is built, there is also a chapter about more advanced techniques within forms and reports. It helps to understand Application Express even better and look behind the scenes.
Programmatic elements in Application Express can provide both simple and complex features to the Application Express framework. So the helpdesk application is extended with conditions, validations on item level and page level, tabular form validations, computations and processes and dynamic actions.

Security in an application is often an afterthought. This book covers this very important topic. The key features of security available within Application Express are added to the application. Authentication is added to the help desk application by making use of a customized authentication scheme. The scheme is used to allow control over users who access the sensitive parts of the application. User access is controlled by access control lists. In the help desk application a check sum is added to the URL. This prevents URL tampering.
Once the application is ready, it needs to be deployed. So you learn how to get an application out of the system and to deploy in the production system. Techniques like export, import, and supporting objects are covered.
Websheets is a new feature in Application Express 4. In the book, you will use the features to build a websheet application from scratch. With the application you can manage your corporate soccer team. Websheets is a very nice feature to manage the soccer team. A complete example how to manage the soccer team is covered in this book.
Advanced development features are also highlighted in this book. These tools help when dealing with large applications. Features like page locks, application and page groups are covered.
Of course, your Application Express side needs to be monitored as well. Each time a page is accessed, a log entry is stored. Subjects like activity logging, login attempts, and managing workspaces are covered in the book.
The last chapter in the book is about the team development feature. Team development is a tool for managing Application Express projects. All features like milestones, to-dos, bugs, feedback and features are discussed.
This book is a `must' for people starting to work and develop applications in Application Express.
4 of 4 people found the following review helpful
HASH(0xa149b2ac) out of 5 stars Too many errors May 31 2011
By Alembic - Published on
Format: Paperback
This book is generally well conceived, but the sheer volume of errors is distracting at the least and sometimes maddeningly misleading. I have been keeping track of the errors and they are truly rampant. Often they are simple misspells and foolish naming errors, probably from an earlier version that were not changed, but sometimes they are outright wrong and misleading. I have made it to Chapter 7 and the instructions to create an interactive report on page 163 are garbled and I am unsure how to proceed. Watch out for item 4 missing the final period on the session state value translation syntax on page 135, too. My suspicion is that this version was rushed to publication and no one in the group of authors or the publisher took responsibility to make sure that it was properly edited.

Timeliness is of the essence in the fast-paced software field and I can understand the drive to be first to market, but if my code had this many errors, it would never run. I suggest you wait until a new, corrected version is released. I wish I could recommend this book more highly as I think it has a good core and sensible flow.
4 of 4 people found the following review helpful
HASH(0xa149b60c) out of 5 stars Great book, but needs two more edits April 15 2011
By Warren Capps - Published on
Format: Paperback Verified Purchase
This book provides an excellent start for the novice developer trying to learn APEX 4.0. Chapters are very clear and well-organized. The continuing exercize throughout the book is quite a challenge and demonstrates much of the functionality of APEX. Overall, an excellent job.

However (you knew this was coming), I couldn't give it 5 stars for two main reasons.
1. Too many simple editing mistakes. Although, for the most part, they don't impact the overall quality, they are at a minimum annoying, and at their worst confusing to the reader. I found 7 simple errors in the first 30 pages.
2. The exercises needed somebody (not an author) to go through once and identify all the problems. Is the column in the TICKETS table DESCR or DESCRIPTION? Really needs one more look by a technical editor.

All that said, I would still highly recommend it. I plan on using the book as the basis for my APEX 4 classes that I teach. I am hopeful that the errors can be easily fixed in the pdf or kindle versions.
4 of 4 people found the following review helpful
HASH(0xa149b3c0) out of 5 stars Don't waste your time Feb. 9 2012
By E.Guerra - Published on
Format: Paperback Verified Purchase
In spite others said this book was bad, I bought.
I spent my time trying to follow the instructions on [...], but instructions was not clear and had not relation with my screen.
I had to return it next day!
Readers, not buy this book. It is not ready to publishing.
Authors, reviewing this book could become it in a great book. Please, do it.