Wednesday, February 8, 2012

Oracle find column name in the Database

In Order to search a column name in the database

select table_name, column_name from all_tab_columns where column_name like '%ColumnName%'





 
== Disclaimer == This is my personal blog. All data and information provided on this site is for informational purposes only. I do not guarantee accuracy, completeness, currentness, suitability, or validity of any information on this site and will not be liable for anything whatsoever. Use it at your own risk. ==