December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...