|
SQL>
SQL> DECLARE
2 tableName VARCHAR2(30):='temp';
3 sqlString VARCHAR2(150);
4 c INTEGER;
5 ret_code INTEGER;
6 BEGIN
7 sqlString :='create table '||tableName||'(col1 NUMBER NOT NULL)';
8 c :=DBMS_SQL.OPEN_CURSOR;
9 DBMS_SQL.PARSE(c,sqlString,DBMS_SQL.V7);
10 ret_code :=DBMS_SQL.EXECUTE(c);
11 DBMS_SQL.CLOSE_CURSOR(c);
12 END;
13 /
PL/SQL procedure successfully completed.
SQL> drop table temp;
Table dropped.
|