Beginning Oracle Application Express 4 / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $6.16
Usually ships in 1-2 business days
(Save 87%)
Other sellers (Paperback)
  • All (14) from $6.16   
  • New (9) from $31.07   
  • Used (5) from $6.16   


Beginning Oracle Application Express 4 introduces one of the most talked-about development platforms to come out of Oracle Corporation in years. Oracle Application Express, called APEX for short, enables rapid and easy development of web-based applications that make full use of Oracle Database.The release of APEX 4 brings a huge leap forward in terms of functionality and usability for both the developer and the end user. Power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company.

Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX, Beginning Oracle Application Express 4 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. While the book assumes a foundational knowledge of SQL and PL/SQL, all code used is documented and explained so that those new to the languages will not be lost.

  • Coversbrand-new functionality in APEX 4
  • Provides fully documented and explained example code
  • Guides you through creating a working and fully deployable application

What you’ll learn

  • Design, code, and troubleshoot APEX applications
  • Create forms and generate reports
  • Apply best-practices to database and application design
  • Create intuitive navigation that inspires confidence amongst users
  • Secure your applications from outside attack
  • Deploy applications for one, a dozen, or hundreds of users

Who this book is for

Beginning Oracle Application Express 4 is for programmers and power users wanting to create rich, data-centric applications that are web-based, and that rest on Oracle’s industry-leading database technology.

Table of Contents

  1. An Introduction to APEX
  2. A Developer's Overview
  3. Identifying the Problem & Designing the Solution
  4. SQL Workshop
  5. Application & Navigational Components
  6. Forms & Reports—The Basics
  7. Forms & Reports—Advanced
  8. Programmatic Elements
  9. Security
  10. Application Deployment
  11. Understanding Websheets
  12. A WebSheets Example
  13. Extended Developer Tools
  1. Managing Workspaces
  2. Team Development
Read More Show Less

Product Details

  • ISBN-13: 9781430231479
  • Publisher: Apress
  • Publication date: 4/5/2011
  • Edition number: 1
  • Pages: 440
  • Product dimensions: 7.50 (w) x 9.20 (h) x 1.10 (d)

Meet the Author

Doug Gault is the APEX Practice Director at Enkitec, an Oracle Platinum partner founded in 2004 which provides consulting, education, and products based around Oracle Technology. He has been working with Oracle since 1988, starting with version 5.1B, SQL*Forms 2.0, and RPT/RPF. He has focused his career on Oracle's development technologies, spending the majority of that time dedicated to web-based technologies including the OWA Web Toolkit, PL/SQL Server Pages, WebDB, Oracle Portal, and more recently HTML-DB and APEX.

Doug's many years of Oracle experience have taken him all over the world to participate in some truly ground-breaking projects. Doug has presented at and participated in roundtable discussions at a number of conferences including Oracle OpenWorld, UKOUG, and ODTUG's APEXposed & Kaleidoscope conferences. 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 experience.

Doug is an Oracle Ace and can be found on Twitter as @dgault_apex and on his blog You can contact Doug at

Karen Cannell is president of TH Technology, a small consulting firm providing Oracle technology services, focusing on Application Express. A Mechanical Engineer by degree (one of them), she has analyzed, designed, developed, converted, upgraded, enhanced, and otherwise worked on legacy and commercial database applications for over 25 years, concentrating on Oracle technologies since 1994. She has worked with Application Express since its Web DB and HTMLDB beginnings, and continues to leverage the Oracle suite of tools to build quality web applications for clients in government, medical, and engineering industries. Karen can be contacted at

Patrick Cimolini is a principal with Patrick International APEX Consulting, a consultancy that specializes in project management and software development services for Oracle Application Express (APEX) projects. His formal training in engineering, business administration, and project management are complemented by 30 years of experience that has evolved through mainframe, client/server, and web platforms. Patrick has enjoyed attending the Oracle Development Tools User Group (ODTUG) conferences where he has been a regular presenter. His Oracle experience dates back to the early 1990s.

Tim St. Hilaire has been working with Oracle as a developer, integrator, and architect for over ten years. His most recent focus is on the APEX tool set and integration opportunities available both internally and externally. Leading a team of developers, APEX has been integrated as a strategic tool within his current business. Sharing those experiences with others is both a hobby and a passion.

Martin Giffy D'Souza is Co-Founder and CTO at ClariFit, a consulting firm and custom solutions provider specializing in APEX and PL/SQL development. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle APEX technology stack.

In addition to his day job, Martin is the author of the popular blog He is also a designated Oracle ACE Director, and has co-authored and authored various APEX books. He has also presented at numerous international conferences such as APEXposed, COUG, and ODTUG Kscope, for which he won the Presenter of the Year award in 2011.

Martin holds a Computer Engineering degree from Queen's University in Kingston, Ontario, Canada. You can contact Martin at

Read More Show Less

Customer Reviews

Average Rating 4
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted April 17, 2011

    It's how a "beginning" book should be written

    This books is written for someone who is new to Oracle's Application Express (ApEx) RAD development tool. To follow along with the book you will either need to have Oracle and ApEx installed (easy to follow instructions on setting ApEx up are included in the ApEx download from Oracle), or sign up for an account online (see book for web site). I had installed ApEx on my machine prior to getting the book but I also used the online service to test it out. Signing up for a workspace online took just a few minutes and my account was created within a few minutes. The book starts out giving an introduction to ApEx, what it is and where it got it's beginnings. The second chapter walks you through the UI and helps to get you acquainted with things. From there you begin your journey into building a help desk/ticketing system from the ground up. Each chapter walks you through the different aspects of building your application. The authors walk you through using the wizards to build up most of what you need, and then show you how to make changes to the wizard's code so you can tweak whatever you might need to fit your standards. First you learn how to use ApEx to create your database objects and how to import and run scripts that were created outside the platform. From there you are shown how to build your application, navigation and import data from spreadsheets. After that you are walked through two chapters on building reports and forms. Once you've learned that you learn about the programmatic abilities in ApEx such as conditionally showing pages, computing and validating values and setting up processes and actions. Security is next on the list and how to set it up on your application. Finally you are shown how to deploy your finished application. The next two chapters explain how to build a websheet application which the authors liken to a blog or wiki site. From there you move onto a chapter dealing with advanced developers tools such as locking pages (all ApEx work is done in a browser interface and there is no source control), monitoring your application, setting up your build options, etc. The last two chapters deal with managing workspaces inside of ApEx and how Team Development can help keep things straight. I really like the book and it's step by step setting up of an application. The authors did a good job at showing a beginner what they need to know to get a basic application set up and deployed. I feel they gave enough "hand holding" in the earlier chapters and in the later chapters just referred you back to where you could find the instructions if you forgot how to do something. They obviously didn't touch on everything that ApEx can do and left that for other books to explain, which is how it should be for a book like this. There are more typos in this book than I have seen in other Apress titles. Most of these are nothing more than mere annoyances in the text, but there are a couple coding errors that I noticed and a couple places that refer you to later chapters but still had the '??' place holders since the layout had not been completed yet. Even with these issues, the book is definitely worth reading for those who want to learn about using ApEx for driving their web site.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted May 2, 2011

    A Great Place To Start With APEX4 - Highly Recommend

    Oracle Application Express 4(APEX4) is the latest version of Oracle's web application development platform. This book covers all aspects of this product as it relates to developing web applications. For example, it discusses the application, navigation in the tool, security, team development and more. APEX4 installs as a schema in an Oracle database so the book also discusses the schema, dictionary views and integration with other Oracle products. Beginning Oracle Application Express 4 does a really good job of introducing this product. APEX4 is extremely robust and full-featured. Beginning Oracle Application Express 4 does a very good job of introducing the reader to these features. It walks the reader through a step-by-step approach to creating a typical web application. It explains every step in detail, using not only step-by-step instructions but also a lot of pictures and screenshots. This is a tremendous help for a beginner. In addition to the step-by-step instructions, the author does several things that I liked very much and definitely added to my understanding and ability to work independently and creatively as I move past the book. The author talked about related issues, things you didn't really need to know to follow the instructions but were great to have for a really good understanding. For example, when talking about the APEX4 Search functions, he talked about understanding Session State so that I would understand how APEX keeps track of values. Another feature that I really liked was his "Look behind the scenes" pieces. After each major task, he used this to explain what, and how, APEX is doing. He also pointed out here, the kinds of things you should be looking for to insure that APEX is doing what you want and expect it to do. One of the really great things is that all you need to get started is the book, a basic knowledge of sql and a basic knowledge of relational databases (not necessarily Oracle). The author provides all the rest. You can download all the scripts, data, etc. that you need from the publishers website. If you do not have access to APEX4 or an Oracle database, the author shows you where you can get free access to Oracle's APEX4 and database to use on the web. This is a wonderful site that makes it seem like you are the only user. If I had to make one constructive comment, it would be that there are "typos" in the book. This can be confusing but with all the other descriptions, pictures and screenshots to guide you, it should not cause a serious problem. By using this book, in only a few hours, I developed a sample web application that had created database tables, created lookup tables(fairly hard to do without a tool like this), created interactive web pages that updated the database, dynamic reports that could be searched and sorted by any column, a help system and other really impressive stuff. Almost all of this was done, automatically, by pointing and clicking on the tool. I highly recommend this book to anyone who is interested in developing web applications using an Oracle database.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)