Oracle查看字段所属表

SELECT
　　table_name
FROM
　　dba_tab_columns
WHERE
　　column_name = upper('userid') 
ORDER BY
　　table_name;