Tips and Tricks in a world of Mix

Posts tagged ‘all tables’

Get all your tables that not in your string array

select table_name
from user_tables
where table_name not like ‘%<some condition if needed>%’
and table_name not in (  ‘value_table1’, ‘ value_table2’… )

 

Tag Cloud

%d bloggers like this: