DYN1: Introduction to Dynamic SQL in PL/SQL (PL/SQL Channel)

This video explains the difference between static and dynamic SQL, reviews the four methods of dynamic SQL, and lays out the plan for this series.

========================================
Practically Perfect PL/SQL with Steven Feuerstein

Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

[indulakshmi]

Hi Steve ! First of all would like to say thank you for the Excellent videos . Also Could you please do performance tuning videos like what is the role from the developers side, as lot of jobs ask

[narendrae]

Hi Steve, thank you very much for videos on execute immediate. I have a scenario on trigger how to execute :new qualifier in execute immediate?

[mauroformigoni]

Hi Steve! We have several procedures that perform a SELECT in which end user can fill one or more parameters, and query is meant to apply or not the filter considering whether the parameter is NULL or not. Do you consider that this goal is best achieved writing a dynamic SQL, having the WHERE clause constructed according to the parameters that have or have not a value set? Or would it be better to write some short circuit WHERE clause, like WHERE (:param1 is NULL or t1.column1 = :param1) OR (:param2 is NULL or t1.column2 = :param2) ? When I ask which option do you consider to be best I mean in terms of maintainability and execution performance.