是系统视图 说明数据库中所有表的字段结构内容的
SELECT *
FROM all_tab_columns x
WHERE x.column_name = '****'
OWNER
TABLE_NAMECOLUMN_NAMEDATA_TYPEDATA_TYPE_MODDATA_TYPE_OWNERDATA_LENGTHDATA_PRECISIONDATA_SCALENULLABLECOLUMN_IDDEFAULT_LENGTHDATA_DEFAULTNUM_DISTINCTLOW_VALUEHIGH_VALUEDENSITYNUM_NULLSNUM_BUCKETSLAST_ANALYZEDSAMPLE_SIZECHARACTER_SET_NAMECHAR_COL_DECL_LENGTHGLOBAL_STATSUSER_STATSAVG_COL_LENCHAR_LENGTHCHAR_USEDV80_FMT_IMAGEDATA_UPGRADEDHISTOGRAM