Question

Oracle中查询序列的语法是什么？

不知道有多少个序列？
用什么语句可以一下子全查出来？

Answer 1

在DBA_SEQUENCES,USER_SEQUENCES,ALL_SEQUENCES中有。具体列你可以
DESC DBA_SEQUENCES;查看
比如：
SQL> select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='DBSNMP';

SEQUENCE_OWNER SEQUENCE_NAME
------------------------------ ------------------------------
DBSNMP MGMT_RESPONSE_CAPTURE_ID
DBSNMP MGMT_RESPONSE_SNAPSHOT_ID

SQL> select count(*) from dba_sequences where sequence_owner='DBSNMP';

COUNT(*)
----------
2

Answer 2

楼上回答的是正确的。