oracle查看已创建的序列

select 
a_seq.sequence_name --序列名
,a_seq.SEQUENCE_OWNER --序列所属用户
--,a_seq.*
from ALL_SEQUENCES  a_seq;
--
select 
u_seq.sequence_name --序列名
,u_seq.*
from USER_SEQUENCES u_seq;
--按DBA账号查询所有序列
select 
d_seq.sequence_name --序列名
,d_seq.*
from DBA_SEQUENCES d_seq;