O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

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

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

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