Oracle Database Dynamic SQL Insert values in dynamic SQL
Example
Example below inserts value into the table from the previous example:
declare
query_text varchar2(1000) := 'insert into my_table(id, column_value) values (:P_ID, :P_VAL)';
id number := 2;
value varchar2(100) := 'Bonjour!';
begin
execute immediate query_text using id, value;
end;
/
