Oracle Magazine, Jan/Feb 2018
Database Developer PL SQL Just Say No Unless You Cant Dynamic SQL is powerful flexible and fraught with risk Use it only when absolutely necessary Whether you run Oracle Database in the cloud or in a virtual machine you will need to write SQL statements to both fetch from and change the contents of tables And when you want that SQL to run as quickly as possible be as secure as possible and be as easy to maintain as possible you will write PL SQL APIs in the form of packages around your SQL statements So far so good But then you need to decide the following how am I going to write that SQL inside PL SQL You have two basic choices Static SQL Dynamic SQL A SQL statement is static also referred to as embedded SQL when the statement is parsed at the time your PL SQL program unit is compiled Here is an example of a code block with static SQL ORACLE MAGAZINE JANUARY FEBRUARY 2018 72 ORACLE DATABASE By Steven Feuerstein
You must have JavaScript enabled to view digital editions.