oracle工具类

mac2022-06-30 23

查询表中有多少列

select count(1) from user_tab_columns where table_name=upper('M_ReturnPicture')

//查询数据中某个用户所创建的表数量

SELECT table_name FROM all_tables WHERE owner = upper('rpt');

select * from all_tables where owner = upper('userecc') and (table_name like 'T_%' or table_name like 'M_%' or table_name like 'W_%')

转载于:https://www.cnblogs.com/lidj/p/3798960.html