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 dimensions:||7.50(w) x 9.25(h) x 0.62(d)|
About the Author
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.
Most Helpful Customer Reviews
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