update T set created=created-dbms_random.value(1,3650); --让created列的年份成为近10年的年份 select to_char(created,'yyyy-mm-dd') created_date,owner,object_type,count(object_name) from t where created > ...
表XXDO.XXD_CST_ITEM_COST_DETAILS_T 和 XXDO.XXD_ACTUAL_COST_HIST_DETAILS_T 上都没有主键约束,两个表在INVENTORY_ITEM_ID, ORGANIZATION_ID 有索引。 "ORGANIZATION_ID" NUMBER NOT NULL ENABLE, "COST_TYPE_ID" NUMBER NOT NULL ...