Plsql search columns
From John Freier
Revision as of 15:48, 27 December 2012 by Jfreier (Talk | contribs) (Created page with 'Search for a column. select * from all_tab_columns where 1=1 and owner = 'OWNER' --and table_name = 'TABLE' --and column_name LIKE '%COLUMN%';')
Search for a column.
select * from all_tab_columns where 1=1 and owner = 'OWNER' --and table_name = 'TABLE' --and column_name LIKE '%COLUMN%';
