O'Reilly logo

Oracle Application Express 3.2 by Matthew Lyon, Arie Geller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. APEX SQL Workshop

APEX is a data-centric application development environment. As such, the application data infrastructure, which consists of tables, views, indexes, sequences, triggers, etc., is very important.

When dealing with an application data infrastructure, we have two major initial phases—planning the data model and implementing it. APEX can help us a lot in the implementation phase by providing several user-friendly and declarative-based utilities that allow us to define (and maintain) the major database objects that we need for our application.

Many developers are not necessarily trained DBAs. Moreover, in the age of graphical integrated development environments, many developers, including the experienced ones, don't always ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required