Hi there, I have to check if any views or tables have column name "bucket_no". I can search in tables by using query:
SELECT column_name, table_name FROM all_tab_columns WHERE lower(column_name) LIKE '%bucket_no%' But, i didnt get how to search in views. I am working on impact analysis. So i need to check which tables or views has this column. Please help me.... Thanx'N'Regards Roopesh --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
