问题描述
select a.talname,count(1) from (SELECT distinct 'ysj.'||table_name talname from all_tab_cols where table_name IN ('YZ_YBZHF','YZ_JYMX','YZ_JYHZ','YS_ZLXGFORICK','YS_ZKZL', 'YS_ZKLCZL','YS_ZKHPZL_SBSJ','YS_ZKHPZL2','YS_ZKHPZL','YS_ZKFFJL', 'YS_ZKBPZL','YS_ZHHRHP','YS_ZHHRBP','YS_KZLGXCL','YS_JYKZL','YS_JYKDYMX', 'X_YWLCJL','X_YWLC','X_BPWJ','NB_ZKZL','S_ZHCSOLD','S_ZHCS','NB_ZKJL', 'NB_SBHPERR','NB_SBHP','NB_PLZKJLXG','NB_PLZKJL','NB_GSHK','SYS_USER','X_ICKCZY','SYS_WSSB_USER') )a group by a.talname;我想查询table_name中的表中的记录数,但是每次查询都只是下面显示的结果:到底改怎么修改?不胜感激11dgsbsj.NB_ZKZL12dgsbsj.SYS_USER13dgsbsj.S_ZHCSOLD14dgsbsj.X_YWLCJL15dgsbsj.YS_JYKDYMX16dgsbsj.YS_ZKBPZL17dgsbsj.YS_ZLXGFORICK18dgsbsj.NB_ZKJL19dgsbsj.YS_ZHHRBP110dgsbsj.NB_SBHP111dgsbsj.X_YWLC112dgsbsj.YS_ZKHPZL2113dgsbsj.NB_PLZKJLXG114dgsbsj.SYS_WSSB_USER115dgsbsj.X_BPWJ116dgsbsj.YS_JYKZL117dgsbsj.YS_KZLGXCL118dgsbsj.YZ_YBZHF119dgsbsj.YZ_JYMX120dgsbsj.YS_ZKFFJL121dgsbsj.YS_ZKHPZL122dgsbsj.NB_GSHK123dgsbsj.NB_PLZKJL124dgsbsj.S_ZHCS125dgsbsj.YZ_JYHZ126dgsbsj.YS_ZHHRHP127dgsbsj.YS_ZKHPZL_SBSJ128dgsbsj.YS_ZKZL129dgsbsj.NB_SBHPERR130dgsbsj.YS_ZKLCZL1 问题补充:地狱牢笼 写道
解决方案
select table_name,num_rows from all_tableswhere table_name IN ('YZ_YBZHF','YZ_JYMX','YZ_JYHZ','YS_ZLXGFORICK','YS_ZKZL', 'YS_ZKLCZL','YS_ZKHPZL_SBSJ','YS_ZKHPZL2','YS_ZKHPZL','YS_ZKFFJL', 'YS_ZKBPZL','YS_ZHHRHP','YS_ZHHRBP','YS_KZLGXCL','YS_JYKZL','YS_JYKDYMX', 'X_YWLCJL','X_YWLC','X_BPWJ','NB_ZKZL','S_ZHCSOLD','S_ZHCS','NB_ZKJL', 'NB_SBHPERR','NB_SBHP','NB_PLZKJLXG','NB_PLZKJL','NB_GSHK','SYS_USER','X_ICKCZY','SYS_WSSB_USER') ;
解决方案二:
select table_name,num_rows from user_tables order by num_rows desc 这个语句也是可以的
解决方案三:
子查询的结果集是tableName, 本身也就一条语句了,当然 count(1) 也是1了DBA权限下可以查询dba_tables,里面有个num_rows列select table_name,num_rows from dba_tables where ...;条件可以根据自己需要来加不过提醒下,num_rows列并不是事实更新的,好像是1小时更新一次,查新之前最好先ANALYZE下analyze table xxx compute statistics;
解决方案四:
select a.talname,a.num_rows from
解决方案五:
select a.talname,a.rows from 你的是什么数据库?
解决方案六:
把count改为rows