Oracle APEX Best Practices

In clearly written chapters you will be guided through different aspects of Oracle Application Express. Varying from setting up your environment to maximizing SQL and PL/SQL. Examples are given based on a simple but appealing case. This book is filled with best practices on how to make the most of Oracle APEX. Developers beginning with application development as well as those who are experienced will benefit from this book. You will need to have basic knowledge of SQL and PL/SQL to follow the examples in this book.

Author Biography

Alex Nuijten works as a database developer and Expertise Lead (database development) for AMIS Services BV in Nieuwegein, the Netherlands. Besides his consultancy work, he also conducts training classes, mainly in SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, and OBUG. He is also a frequent contributor at the Oracle Technology Network forum for SQL and PL/SQL. He has written many articles in Dutch Oracle related magazines, and at regular intervals he writes about Oracle database development on the AMIS Technology Blog, as well as his own blog Notes on Oracle. In August 2010, Alex was rewarded with the Oracle ACE Director membership. Iloon Ellen Wollf started working with Oracle twenty one years ago, employed by several software houses in the Netherlands. Her experience goes back to Oracle Forms version 2 and Report*writer. Almost fourteen years ago, she started working for Oracle Support Services for the developer competency (Oracle Forms, Oracle Reports, Sql Developer and Application Express) assisting customers with solving their software problems. During those years, she applied the knowledge she gained in other ways like coaching new engineers, team leading and teaching Application Express courses for Oracle University. One of her responsibilities in Oracle Support is Global Technical Lead Application Express. She works closely with Sustaining Engineering, Product Development, and Product Management from the Application Express team. Besides that, she is a frequent speaker for different Oracle User Groups about Application Express and SqlDeveloper. After Learco received his MSc in Informatics in 1993, he started working with the early versions of Oracle Forms (3.0), Reports (1.1) and Designer (1.2.1). When WebDB was launched, Learco made the first steps on building internet applications. When APEX (HTMLDB) hit the market, he saw the potential of this tool and built a complete music download store with it in 2004, including integration with email, reports and payment service providers. This was one of the very first serious applications ever built with APEX. Nowadays, Learco is dedicated to APEX and PL/SQL development. He is a very enthusiastic technician, trainer of advanced APEX courses, presenter at conferences, organizer of seminars, committee member of the OGh (Oracle user group in the Netherlands) and member of the editorialcommittee for Oracle magazine ‘OGh Visie’. Together with a companion Learco started his own company, Itium, in 1999, which specializes in Oracle technology.