To select the tables which are containing particular column name, use following query.
SELECT * FROM user_tab_columns WHERE column_name LIKE 'ATR%'
Above query displays table names which are containing column names starting with “ATR”.
Anitha Rosary Stephen
Subscribe to our e-mail newsletter to receive updates.
Mail (will not be published) (Required)