Query all sequences in Oracle

Query all sequences in Oracle:

Note:

1. You must log on as an administrator;

2. sequence_owner must be in upper case, regardless of whether your user name is in upper case. Only uppercase letters can be recognized.

1. -- View All sequences of current users
2. Select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences where sequence_owner = 'username ';
5. -- Query the total number of user Sequences
6. Select count (*) from dba_sequences where sequence_owner = 'username ';
9. -- Example:
10. Select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences
11. Where sequence_owner = 'wgb;
13. Select count (*) from dba_sequences where sequence_owner = 'wg ';
15. SQL> select SEQUENCE_OWNER, SEQUENCE_NAME from dba_sequences
16. 2 where sequence_owner = 'wg ';
18. SEQUENCE_OWNER SEQUENCE_NAME
19. ------------------------------------------------------------
20. WGB SEQ_FOR_TEST
21. WGB SEQ_WGB_ADMIN
22. WGB SEQ_WGB_COMMON
23. WGB SEQ_WGB_COMMONS
24. WGB SEQ_WGB_CONTACTOR
25. WGB SEQ_WGB_FACES
26. WGB SEQ_WGB_MEMBER
27. WGB SEQ_WGB_MESSAGE
28. WGB SEQ_WGB_MONEY_USER
30. Nine rows have been selected.
32. SQL> select count (*) from dba_sequences where sequence_owner = 'wg ';
34. COUNT (*)
35. ----------
36. 9