thisismynota
Monday, April 29, 2013
[Oracle] - Select table contains column name
Tested on Oracle11g
Return all the tables in my schema which have the column name "INST_CODE".
SELECT
table_name
FROM
user_tab_cols
WHERE
column_name
=
'INST_CODE'
ORDER
BY
table_name
ASC;
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment