Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

EXECUTE IMMEDIATE

SQL> SQL> SET ECHO ON SQL> SQL> BEGIN   2      EXECUTE IMMEDIATE 'CREATE TABLE YOURTABLE ('   3                        || 'YOURROW NUMBER, '   4                        || 'YOURDESC VARCHAR2(50))';   5  END;   6  / PL/SQL procedure successfully completed. SQL> SQL> drop table yourtable; Table dropped. SQL> --