oracle 查询所有用户下的表、字段、表名

1.根据表名注释查询表

select * from all_tab_comments where comments like ‘%姓名表注释%’

2.根据字段注释查询表

select * from all_col_comments t
where comments like ‘%张三注释%’

3.根据表名查询表

select * from all_tables where table_name=‘表名’