Plsql search columns

From John Freier
Jump to: navigation, search

Search for a column. 

select * 
from all_tab_columns
where 1=1
and owner = 'OWNER'
--and table_name = 'TABLE'
--and column_name LIKE '%COLUMN%';
Retrieved from "http://wiki.johnfreier.com/index.php?title=Plsql_search_columns&oldid=511"