如何查询某个schema下所有的序列？
如题

------解决方案--------------------
select * from user_sequences;
------解决方案--------------------
查看你当前用户下的序列：
select * from user_sequences ;
------解决方案--------------------
select * from user_objects
where object_type='SEQUENCE'
------解决方案--------------------

探讨

引用:
如题

select SEQUENCE_NAME from dba_sequences where SEQUENCE_OWNER='USER'