SET SERVEROUTPUT ON
DECLARE
TBSTMT VARCHAR2(2000):='CREATE TABLE DEMO (ID NUMBER,MSG VARCHAR2(20))';
BEGIN
EXECUTE IMMEDIATE TBSTMT;
END;
DECLARE
TBSTMT VARCHAR2(2000):='CREATE TABLE DEMO (ID NUMBER,MSG VARCHAR2(20))';
BEGIN
EXECUTE IMMEDIATE TBSTMT;
END;
You can create/drop tables in PL/SQL block with Execute immediate command
ReplyDeleteactually any programming language follows pre/post validations for host variable
here pre checking wl be done,so at the time of compilation we have to submit all host variables,but we can't with ddl stms,so where ever we keep Execute immediate stmt that stmt wl be validate at runtime only.
this is nothing but Dynamic SQL.previously we are using in-built pakage ,now execute immediate command .