Difference between revisions of "Plsql search columns"
From John Freier
(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%';') |
(No difference)
|
Latest revision as of 15:48, 27 December 2012
Search for a column.
select * from all_tab_columns where 1=1 and owner = 'OWNER' --and table_name = 'TABLE' --and column_name LIKE '%COLUMN%';