Advertisement

Dynamic SQL

  • Josh Juneau
  • Matt Arena

Abstract

Oracle provides dynamic SQL as a means for generating DML or DDL at runtime. It can be useful when the full text of a SQL statement or query is not known until application runtime. Dynamic SQL can help overcome some of the limitations of static SQL, such as generating a full SQL query based upon some user-provided information or inserting into a specific table depending upon a user action within your application. Simply put, the ability to use dynamic SQL within PL/SQL applications provides a level of flexibility that is not attainable with the use of static SQL alone.

Keywords

Bind Variable Update Statement Employee Record Application Runtime Dynamic Query 
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

© Josh Juneau and Matt Arena 2010

Authors and Affiliations

  • Josh Juneau
  • Matt Arena

There are no affiliations available

Personalised recommendations