查询表中有多少列
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_%‘)