閱讀175 返回首頁    go 阿裏雲 go 技術社區[雲棲]

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

  上一篇：go 微軟成功收購NVIDIA|微軟的野望
  下一篇：go 10家互聯網上市公司一年成績單