- Shopping Bag ( 0 items )
Want a NOOK? Explore Now
Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it.
"Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.
In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.
Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need.
"Oracle APEX: Best Practices" is where practical development begins!
Approach
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.
Who this book is for
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.
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
Overview
Have you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it.
"Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, ...