--查看表名称
select * from user_tab_comments where table_name like 'TB_%';
如果如下:
2.查看表的名称,列名称,字段类型信息
select col.COLUMN_NAME as 列名 ,col.NULLABLE as ISNull,
col.DATA_TYPE,col.DATA_LENGTH,col.DATA_PRECISION,col.DATA_SCALE,comm.COMMENTS
from user_tab_comments tab inner join user_tab_columns col on tab.TABLE_NAME=col.TABLE_NAME
inner join user_col_comments comm on col.TABLE_NAME=comm.TABLE_NAME and col.COLUMN_NAME=comm.COLUMN_NAME
where col.TABLE_NAME='TP_PC_BFEXMPLAN'
order by col.COLUMN_ID asc;
结果如下: