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 ...

Get Understanding Oracle APEX 5 Application Development, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.