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