Dynamic SQL in PL/SQL

Held on July 3 2018

Steven Feuerstein offers a quick overview of key recommendations for dynamic SQL in PL/SQL, including: only use dynamic SQL when it's necessary, choose binding over concatenation, protect from SQL injection with DBMS_ASSERT.

01:22 What's wrong with this code?
02:15 Only use dynamic SQL when necessary
04:00 Bind, don't concatenate
09:47 Protect your concatenations
13:03 Other dynamic SQL good-to-knows
17:50 Take advantage of the Oracle Dev Gym and Live SQL websites
21:27 Q&A

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.