select * from all_sequenceswhere–sequence_owner=’RRRRR’ andsequence_name like upper(‘%ZZZZZZZ%’)order by sequence_owner, sequence_name ;