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. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com