Dynamic SQL and System Packages - Oracle PL SQL Course - Lesson 27 | SQL courses

Duration: 16:39 min

Summary: The Oracle PL/SQL language allows the creation of dynamic SQL statements, which are normal SQL commands created from string concatenation. This technique is useful in scenarios where you don’t know the name of the objects until runtime and need to create a flexible script. This video shows how to create and run dynamic SQL statements using the EXECUTE IMMEDIATE command with its options to assign variables and store the resultset. This video also briefly describe some other important system packages that must be known by any developer that work with PL/SQL.