An example of code using native dynamic SQL : Dynamic SQL statement « PL SQL Statements « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Statements
3. Dynamic SQL statement

SQL> DECLARE
  2    tableName VARCHAR2(30):='temp';
  3    sqlString VARCHAR2(150);
  4  BEGIN
  5    sqlString :='create table '||tableName||'(col1 NUMBER NOT NULL)';
  6    EXECUTE IMMEDIATE sqlString;
  7  END;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table temp;

Table dropped.