How to select table name with column name in oracle?

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”.

Share This Post

Related Articles

Leave a Reply

© 2018 Techy Diary. All rights reserved.
Powered by Charvi Groups