Question

oracle 修改表名为当前表名加上当前日期

ALTER TABLE C1 RENAME TO C1加上当前日期

Answer 1

declare
V VARCHAR2(4000);
BEGIN
v:=' rename c1 to c1'||to_char(SYSDATE,'yyyymmdd');
EXECUTE IMMEDIATE v;
end;