Can one call DDL statements from PL/SQL?  

One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDATE" statement.
Users running Oracle versions below 8i can look at the DBMS_SQL package (see FAQ about Dynamic SQL).
begin
EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)';
end;
NOTE: The DDL statement in quotes should not be terminated with a semicolon.

Answered by Shishir , an ibibo Master, at 7:45 PM on November 27, 2008

Yes, One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDIATE" statement (native SQL).

Answered by Kamlesh B , an ibibo Specialist, at 7:11 PM on November 27, 2008

One can call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL by using the "EXECUTE IMMEDIATE" statement (native SQL). Examples:

begin
EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)';
end;

begin execute Immediate 'TRUNCATE TABLE emp'; end;

DECLARE
var VARCHAR2(100);
BEGIN
var := 'CREATE TABLE temp1(col1 NUMBER(2))';
EXECUTE IMMEDIATE var;
END;

NOTE: The DDL statement in quotes should not be terminated with a semicolon.

Users running Oracle versions below Oracle 8i can look at the DBMS_SQL package .

Answered by Nagendra , an ibibo Master, at 7:04 PM on November 27, 2008