我想查询每个表中的数据有多少？

Question

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中的表中的记录数，但是每次查询都只是下面显示的结果：到底改怎么修改？不胜感激1
1 dgsbsj.NB_ZKZL 1
2 dgsbsj.SYS_USER 1
3 dgsbsj.S_ZHCSOLD 1
4 dgsbsj.X_YWLCJL 1
5 dgsbsj.YS_JYKDYMX 1
6 dgsbsj.YS_ZKBPZL 1
7 dgsbsj.YS_ZLXGFORICK 1
8 dgsbsj.NB_ZKJL 1
9 dgsbsj.YS_ZHHRBP 1
10 dgsbsj.NB_SBHP 1
11 dgsbsj.X_YWLC 1
12 dgsbsj.YS_ZKHPZL2 1
13 dgsbsj.NB_PLZKJLXG 1
14 dgsbsj.SYS_WSSB_USER 1
15 dgsbsj.X_BPWJ 1
16 dgsbsj.YS_JYKZL 1
17 dgsbsj.YS_KZLGXCL 1
18 dgsbsj.YZ_YBZHF 1
19 dgsbsj.YZ_JYMX 1
20 dgsbsj.YS_ZKFFJL 1
21 dgsbsj.YS_ZKHPZL 1
22 dgsbsj.NB_GSHK 1
23 dgsbsj.NB_PLZKJL 1
24 dgsbsj.S_ZHCS 1
25 dgsbsj.YZ_JYHZ 1
26 dgsbsj.YS_ZHHRHP 1
27 dgsbsj.YS_ZKHPZL_SBSJ 1
28 dgsbsj.YS_ZKZL 1
29 dgsbsj.NB_SBHPERR 1
30 dgsbsj.YS_ZKLCZL 1

Answer 1

select table_name,num_rows from all_tables
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') ;