BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE TEST_DDL(ID NUMBER)';
END;
BEGIN
INSERT INTO TEST_DDL(ID) VALUES (10);
END;
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE TEST_DDL';
END;
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE TEST_DDL';
END;
EXECUTE IMMEDIATE 'CREATE TABLE TEST_DDL(ID NUMBER)';
END;
BEGIN
INSERT INTO TEST_DDL(ID) VALUES (10);
END;
BEGIN
EXECUTE IMMEDIATE 'TRUNCATE TABLE TEST_DDL';
END;
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE TEST_DDL';
END;
This comment has been removed by the author.
ReplyDelete