oracle 搜索数据库中某个字段的属于哪个表和用户的sql语句。

是系统视图 说明数据库中所有表的字段结构内容的

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