O'Reilly logo

Understanding Oracle APEX 5 Application Development, Second Edition by Edward Sciore

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

image

Dynamic SQL

In this book, you have seen many examples of pages that are customized by session state values. For example, the SQL source query of a report is a good candidate for customization, as is an SQL statement in a process that accesses the database. A large portion of this customization comes from bound references in SQL statements.

However, there are limits to what can be customized. A reference to a session-state variable can replace a constant in the SQL query, but it is not allowed to replace a table name or a column name. In this chapter, you will examine a technique called dynamic SQL, which overcomes this limitation by ...

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