PL/SQL与Java一起删除超过3天的表

Question

对于下面的PL/SQL语句查询，删除10天前的表

String s = "begin
    for xx in ( select tableName from ALLTABLES where regexp_like(tableName, '  ABCD[[:digit:]]{8}'  ) and to_date(substr(tableName, -8), ' yyyymmdd' ) <  trunc(sysdate) - 3) 
    loop
    execute immediate ' drop table'  ||xx.tableName ||'  purge'  ;
    end loop;
    end;"

我正在使用Callable语句

CallableStatement cs = null;
cs = conn.prepareCall(s);
cs.execute(rplSql);

但是这似乎显示了无效的SQL语句，有什么想法吗？

Answer 1

尝试：

select table_Name from ALL_TABLES where regexp_like(table_Name, '  ABCD[[:digit:]]{8}')

in for语句