In this book, you have seen many ways to use session state values to customize a page. 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. Much of this customization involves bound variable 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. This chapter examines a technique called dynamic SQL, which ...
