摘要: 单表Insert into的语句就不说了,这里主要说插入多条语句的说明 For a multitable insert operation, each expression in the values_clause must refer to columns returned by the sele 阅读全文
posted @ 2021-10-22 14:35 星小梦 阅读(1245) 评论(0) 推荐(1) 编辑
摘要: declare v_sql varchar2(1000); data_count number; begin -- OWNER是模式名 tablespace_name是表空间 for cur_table in (select distinct table_name from ALL_ALL_TABL 阅读全文
posted @ 2021-10-22 09:54 星小梦 阅读(986) 评论(0) 推荐(0) 编辑