Difference between revisions of "Plsql search columns"

From John Freier
Jump to: navigation, search
(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%';