select text from dba_source where owner in ('SCHEMA1', 'SCHEMA2')