摘要:
批量创建sequencedeclare type v_array is varray(19) of varchar2(100); v_index number; v_arr v_array:=v_array('gen_table','gen_table_column','sys_config','s 阅读全文
摘要:
1.查询当前数据库下 每个表的数据行数: select a.name,MaxRows =Max(b.rows)from sys.tables a inner join sys.partitions b on a.object_id=b.object_idgroup by a.name 阅读全文