CHAPTER 11
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
