oracle sql语句如何判断序列是否存在？

[scott]

oracle sql语句如何判断序列是否存在？

[cyousor]

SELECT count(*) FROM All_Sequences where Sequences_name='大写序列名';

[suiziguo]

SELECT COUNT(*) FROM user_sequences
WHERE sequence_name='';

若为0，则名为sequence_name值的sequence不存在，否则存在

[YY_MM_DD]

SQL> select * from all_sequences i where i.sequence_name = 'KKKKK';