Advertisement

Native Dynamic SQL and Dynamic PL/SQL

  • Bulusu Lakshman

Abstract

Oracle supports two types of SQL: static SQL and dynamic SQL. In static SQL, the SQL statement is fully known at compile time and syntax and semantic references are resolved at compile time. In dynamic SQL, the SQL statements are constructed as strings and executed dynamically at runtime. This is true for PL/SQL also. Native dynamic SQL is an implementation of dynamic SQL and dynamic PL/SQL that’s integrated into PL/SQL.

Keywords

Exception Handling Bind Variable Total Price Dynamic String Statement Execute 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Bulusu Lakshman 2003

Authors and Affiliations

  • Bulusu Lakshman

There are no affiliations available

Personalised recommendations