--这里演示的是备份表 可以多个表,如果需要请留言
DECLARE sql_tem VARCHAR2(110);
tableName VARCHAR2(110);
BEGIN
SELECT 'APP_TABLE_'||TO_CHAR(SYSDATE,'yyyymmddhh24miss') into tableName FROM dual;
sql_tem := 'create table ' || tableName || ' as select * from APP_TABLE';
dbms_output.put_line(sql_tem);
execute IMMEDIATE sql_tem;
end;
/