352      阿裏雲  技術社區[雲棲]

Oracle查詢所有序列

查看當前用戶的所有序列

select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='用戶名';

查詢當前用戶的序列總數

select count(*) from dba_sequences where sequence_owner='用戶名';

示例

SQL> select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_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行。

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

注意事項

1 必須以管理員身份登錄

2. sequence_owner必須為大寫，不管你的用戶名是否大寫。隻有大寫才能識別

參考資料 https://zhidao.baidu.com/question/140904731

原帖地址 https://blog.csdn.net/wentasy/article/details/8037851

最後更新：2017-04-02 15:14:50

  上一篇： 微軟公司第一次全國大筆試將在10月12日進行！

  下一篇： (0! + 1! + 2! + 3! + 4! + ... + n!)%m