--查看当前用户的所有序列select sequence_owner,sequence_name from dba_sequences where sequence_owner='用户名';--查询当前用户的序列总数select count(*) from dba_sequences where sequence_owner='用户名';--示例：select sequence_owner,sequence_na
--查看当前用户的所有序列select sequence_owner,sequence_name from dba_sequences where sequence_owner='用户名';--查询当前用户的序列总数select count(*) from dba_sequences where sequence_owner='用户名';--示例：select sequence_owner,sequence_name from dba_sequences where sequence_owner=’wgb;select count(*) from dba_sequences where sequence_owner=’ wgb’;sql> select sequence_owner,sequence_name from dba_sequences 2 where sequence_owner='wgb';sequence_owner sequence_name------------------------------ ------------------------------wgb seq_for_testwgb seq_wgb_adminwgb seq_wgb_commonwgb seq_wgb_commonswgb seq_wgb_contactorwgb seq_wgb_faceswgb seq_wgb_memberwgb seq_wgb_messagewgb seq_wgb_money_user已选择9行。sql> select count(*) from dba_sequences where sequence_owner='wgb'; count(*)---------- 9
注意事项：
1.      必须以管理员身份登录；
2.      sequence_owner必须为大写，不管你的用户名是否大写。只有大写才能识别。
参考资料：
http://zhidao.baidu.com/question/140904731