Difference between revisions of "Plsql search tables"

From John Freier
Jump to: navigation, search
(Created page with 'Search all tables. select * from all_tables where 1=1 and owner = 'OWNER' and table_name LIKE '%%';')
 
(No difference)

Latest revision as of 11:12, 27 December 2012

Search all tables.

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