Oracle about the use of dynamic EXECUTE statement execute immediate

SQL statement stitching can be performed using execute immediate when the database handles complex business logic in a developed application scenario

Insert into Tb_temp_public (v1, v2, V3, V4, v5,v6,v7,v8,v9) Select ",", ",", ",", ",", "from dual;

The field inside the Tb_temp_public is dynamically generated after the corresponding value is also dynamically generated when this time execution statement can be used:

Vsql varchar2 (100);

Vsql: = ' insert into Tb_temp_public (v1, v2, V3, V4, v5,v6,v7,v8,v9) Select ', ' ', ' ', ' ', ' ', ' ', ', ', ' from dual ';

To perform this can be done with execute immediate (VSQL);

Oracle about the use of dynamic EXECUTE statement execute immediate