Next: Advantages of PL/SQL
Up: Implementation Environment
Previous: Functions and Procedures
For executing dynamically defined queries, PL/SQL has defined dbms_sql
Package. The following steps are to be taken for executing a dynamic query.
- Open a cursor,
- Parse the string containing the query,
- Bind variables,
- Execute the query,
- Fetch record from the result of the query.
Figure 5.1: PL/SQL Performance
Punit Bhargava
Wed Mar 11 18:50:53 PST 1998