本文介绍了一种通过SQL语句来批量获取数据库中表名的方法。该方法使用了sys_connect_by_path函数来连接表名，并通过rank及ceil函数进行分组处理，适用于大量表的情况。
可根据表的多少,来写exp语句
select max(sys_connect_by_path(table_name, ',')) tablelist
from (select table_name,
ceil(sum(num_rows) over(order by table_name asc) / 20000000) s1,
rank() over(order by table_name asc) rk
from user_tables)
connect by rk = prior rk - 1
and s1 = prior s1
group by s1
select max(sys_connect_by_path(table_name, ',')) tablelist
from (select table_name,
ceil(sum(num_rows) over(order by table_name asc) / 20000000) s1,
rank() over(order by table_name asc) rk
from user_tables)
connect by rk = prior rk - 1
and s1 = prior s1
group by s1
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
