Beginning Oracle Application Express 4

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

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 4.0

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

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. Hehas 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. Doughas presented at and participated in roundtable discussions at a number of conferences including Oracle OpenWorld, UKOUG, and ODTUG's APEXposed &Kaleidoscopeconferences. 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 douggault.blogspot.com. You can contact Doug at [email protected].

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 [email protected]

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 blogwww.TalkApex.com. 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 [email protected].