DECLARE
TYPE table_name_type is TABLE of VARCHAR2(50);
v_table_name table_name_type;
BEGIN
SELECT table_name BULK COLLECT INTO v_table_name FROM user_tables;
FOR i IN 1 .. v_table_name.count LOOP
EXECUTE IMMEDIATE 'truncate table '||v_table_name(i);
COMMIT;
END LOOP;
END;
/
删除一个用户下的所有表数据
最新推荐文章于 2022-11-15 11:21:45 发布