Oracle生成批量清空表数据脚本
时间:2021-07-01 10:21:17
帮助过:13人阅读
‘DELETE FROM ‘ || a.table_name ||
‘; --‘ ||
a.comments
from user_tab_comments a
where a.table_type
in(
‘TABLE‘) and table_name not like
‘SYS_%‘
Oracle生成批量清空表数据脚本
标签:like type class not 清空 数据 delete rac ike