参考:
https://www.cnblogs.com/kongxc/p/9395148.html
– 获取当前用户下的表
select table_name from user_tables where table_name like ‘%ERP_%’;
– 获取所有用户的表
select * from all_tables where table_name like ‘%ERP_PROJECT%’;
– 获取表字段、字段类型、字段长度
select * from user_tab_columns where table_name=‘ERP_PROJECT’;
–获取表字段及注释
select * from user_col_comments where table_name=‘ERP_PROJECT’;