Mohammed Khalique Mohammed Khalique - 7 months ago 13
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

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