Oracle Apex Best Practices

Oracle Apex Best Practices


View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Thursday, October 24


Have you ever wanted to create real–life applications? In this book you’re not only getting APEX best pratices, but will also take into account the total environment of an APEX application and benefit from it. Many examples are given based on a simple but appealing case.

In clearly written chapters you will be guided through all different aspects of Oracle Application Express. Varying from setting up your environment to maximizing SQL and PL/SQL. Many examples are given based on a simple but appealing case.

Product Details

ISBN-13: 9781849684002
Publisher: Packt Publishing
Publication date: 11/05/2012
Pages: 298
Product dimensions: 7.50(w) x 9.25(h) x 0.62(d)

About the Author

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–Wolff 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 Brizzi 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 editorial committee for Oracle magazine 'OGh Visie'. Together with a companion Learco started his own company, Itium, in 1999, which specializes in Oracle technology.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Oracle APEX Best Practices 4 out of 5 based on 0 ratings. 1 reviews.
Boudville More than 1 year ago
Apex is provided by Oracle as a web front end to its 11g database. The book explains that Apex has had a somewhat convoluted history. It was once called HTMLDB, with predecessors named Oracle Flows, Oracle Platform and Project Marvel [sic]. What this shows is a threshing around within Oracle and a continual repositioning and rebranding. Hopefully things have settled down by the current date. At least that appears as an implicit message in the book. We quickly see that the need for Apex is apparent. The complexity of a set of tables that constitute a database under 11g can be mitigated or debugged if you have a simple way via a web browser to delve into those tables and see their contents. There is a choice of 3 web servers. Of these, the Oracle HTTP Server might be the best choice for many readers, for it extends the free Apache http server. On pragmatic grounds, many more readers might already have experience in running Apache and if you are one of them, you can leverage your experience. The other 2 web servers, Apex listener and Embedded PL/SQL Gateway, are worth looking at if you are already well versed in PL/SQL. One nice feature is the advice to use the Logger package to instrument your code. Very helpful once the code complexity rises. Having this debugging built in from the start can save immensely many hours of your time. The book shows many screen captures of SQL statements and the results of applying them to the database. Much of the syntax should be already familiar to Oracle users, or indeed more generally to users of generic SQL databases. The point of the screen shots is to show how easy Apex can generate those. Comment