Mohammed Khalique Mohammed Khalique - 11 months ago 28
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.


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%';