BEGIN
EXECUTE IMMEDIATE
'CREATE TABLE &OWNER.&NAME_' || TO_CHAR(SYSDATE,'YYYYMMDD_HHMI')
|| ' AS SELECT * FROM &OWNER.&NAME';
END;
SI OBJECT BROWSER 备份表数据
最新推荐文章于 2018-12-20 10:37:09 发布
BEGIN
EXECUTE IMMEDIATE
'CREATE TABLE &OWNER.&NAME_' || TO_CHAR(SYSDATE,'YYYYMMDD_HHMI')
|| ' AS SELECT * FROM &OWNER.&NAME';
END;