实例一:
from user_tables t
where (t.TABLE_NAME, t.TABLESPACE_NAME)
in (
('LOCATIONS', 'EXAMPLE')
);
实例二:
select t.TABLE_NAME, t.TABLESPACE_NAME
from user_tables t
where (t.TABLE_NAME, t.TABLESPACE_NAME)
in (select 'LOCATIONS', 'EXAMPLE' from dual);