Re: Find all tables with a particular field

Jaap W. van Dijk wrote:

> Your SELECT will also find views (and clusters) with the column_name
> EMPID. I thought that the OP might not know this and I wanted to warn
> him, because he specifically asked for *tables* containing a column
> with a certain name.
>
> Jaap.

Please don't get me started on how Oracle continues to treat everything like it was a table in the data dictionary. The worst being EXECUTE privilege on a package where you have to use "AND TABLE_NAME = <package_name>; I cringe every time I teach this.

I understand your point and your clarification of what I wrote is appreciated.

Note to Oracle:

CREATE VIEW user_obj_privs AS
SELECT grantee, owner, table_name AS OBJ_NAME, grantor, privilege, grantable, hierarchy FROM user_tab_privs;

No license fee required for the use of this DDL if incorporated into 11g.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group