Sunday, February 11, 2018

Do You Really Need That SQL to Be Dynamic?

DZone Database Zone
Do You Really Need That SQL to Be Dynamic?
Do You Really Need That SQL to Be Dynamic?

Dynamic SQL refers to a SQL statement that is constructed, parsed, and executed "dynamically" at runtime (vs. "statically" at compile time).

It's very easy to write static SQL in PL/SQL program units (one of the great joys of working with this database programming language). It's also quite easy to implement dynamic SQL requirements in PL/SQL.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...