Unit 16.1. Dynamic SQL Utilities
Unit Objectives
After this unit, you will know how to:
Send a Dynamically Generated Query
Most SQL statements in your PL/SQL will be known ahead of time. However, there are situations when you do not know the exact syntax of the query you will need at runtime; for example, a WHERE clause might depend on a sort order selected by a user, or different queries may be run depending on what the user requests to see. Dynamic SQL refers to SQL that is built and run when it is called. The SQL can be built as required, which is why it is called “Dynamic SQL.” The way Dynamic SQL works ...
Get Oracle® Web Application Programming for PL/SQL® Developers 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.
