Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

An example of code using native dynamic SQL

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> drop table temp; Table dropped.