Plsql search tables

From John Freier
Revision as of 12:12, 27 December 2012 by Jfreier (Talk | contribs) (Created page with 'Search all tables. select * from all_tables where 1=1 and owner = 'OWNER' and table_name LIKE '%%';')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Search all tables.

select * 
from all_tables
where 1=1
and owner = 'OWNER'
and table_name LIKE '%%';