1、查询当前用户下的所有表
select * from all_tables where owner='用户名';--用户名必须是大写。
eg: select * from all_tables where owner='ST20200530' and Table_Name like 'PM_S__%'
2、查询表字段
select * from user_tab_columns
eg: select * from user_tab_columns where Table_Name like 'PM_S__%' and owner='ST20200530';