oracle 统计所有表的数据条数
declarev_table varchar2(60);v_num number;beginfor idx in (select * from sys.user_tables) loop v_table:=idx.table_name;execute immediate 'select count(*) from ' || v_table into v_num ;dbms_output.p...
基础运维
2019-05-15 AM
统计数据库所有表的字段数
oracleselect a.table_name,count(a.COLUMN_NAME) from all_tab_columns a where a.owner = '表' group by a.TABLE_NAME; mysql:SELECT a.`TABLE_NAME`,COUNT(*) FROM COLUMNS a WHERE a.`TABLE_SCHEMA` = '表' GR...
经验开发
2019-05-10 AM
oracle不能作为字段名的保留关键字
{ "access": "1", "add": "1", "all": "1", "alter": "1", "and": "1", "...
基础运维
2019-05-06 AM
oracle 删除重复值|批量删除表|禁用约束|删除序列|清空回收站
查找重复值select 键列 from 表 group by 键列 having count(键列) > 1; 删除重复值DELETE from 表 WHERE (键) IN ( SELECT 键 FROM 表 GROUP BY 键 HAVING COUNT(键) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM 表 GROUP BY ...
基础运维
2019-05-05 PM