Dynamic SQL (Introduction)

Overview

Dynamic SQL allows queries to be dynamically constructed as strings and executed at runtime.

Code Examples

SQL

-- Conceptual Dynamic SQL Execution (e.g. Postgres / SQL Server)
EXECUTE IMMEDIATE 'SELECT * FROM ' || table_name_var;

Summary

Dynamic SQL constructs query strings at runtime, useful for dynamic reporting and automated schema tasks.