Using dynamic SQL statements from PL/SQL
Posted: | Categories: Oracle, Programming | Tags: Dynamic statement
Sometimes you need to execute dynamic SQL statements. Starting from Oracle8i you can accomplish this task using the
EXECUTE IMMEDIATE statement. Here are three examples of how you can take advantage of this great statement.
sql_select := 'SELECT * FROM your_table WHERE field1 = :1';
EXECUTE IMMEDIATE sql_select
INTO your_cursor
USING your_parameter_for_field1;In this first example I showed how you can use EXECUTE IMMEDIATE to execute the query and put the result into a cursor.
The USING your_parameter_for_field1 part replaces the :1 bind variable with the value contained in the
your_parameter_for_field1 parameter.