tibero drop table (wildcard 로 지우기)

DECLARE
BEGIN
  DBMS_OUTPUT.ENABLE;
  
  FOR c IN ( SELECT table_name FROM user_tables WHERE table_name LIKE 'ABC_%' )
  LOOP
  	--DBMS_OUTPUT.PUT_LINE(c.table_name);
    EXECUTE IMMEDIATE 'DROP TABLE ' || c.table_name;
  END LOOP;
END;