Mohammed Khalique Mohammed Khalique - 1 year ago 42
SQL Question

How to check all column names of Tables in oracle with regex?

I usually search column names in Oracle as we have 1000+ tables. Is there simpler way to search column names using regex.

For example Column name have CURRENCY or COUNTRY etc.

Answer Source

I think it duplicate.

But can find it using below query.

SELECT column_name, table_name FROM user_tab_columns WHERE column_name='%CURRENCY%' OR column_name='%COUNTRY%';