Oracle查询所有序列

注意事项:

1.必须以管理员身份登录

2.sequence_owner必须为大写,不管你的用户名是否大写。只有大写才能识别。

--查看当前用户的所有序列

selectSEQUENCE_OWNER,SEQUENCE_NAMEfromdba_sequenceswheresequence_owner='用户名';

--查询当前用户的序列总数

selectcount(*)fromdba_sequenceswheresequence_owner='用户名';

--示例:

selectSEQUENCE_OWNER,SEQUENCE_NAMEfrom

where

selectcount(*)fromdba_sequenceswhere

selectSEQUENCE_OWNER,SEQUENCE_NAMEfromdba_sequences wheresequence_owner='WGB';

SEQUENCE_OWNER SEQUENCE_NAME

------------------------------------------------------------

WGB SEQ_FOR_TEST

WGB SEQ_WGB_ADMIN

WGB SEQ_WGB_COMMON

WGB SEQ_WGB_COMMONS

WGB SEQ_WGB_CONTACTOR

WGB SEQ_WGB_FACES

WGB SEQ_WGB_MEMBER

WGB SEQ_WGB_MESSAGE

WGB SEQ_WGB_MONEY_USER

已选择9行。

selectcount(*)fromdba_sequenceswheresequence_owner='WGB';

COUNT(*)

9