select sequence_name from user_sequences where sequence_name='序列名';
SELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE='SEQUENCE' AND OBJECT_NAME='XXXX'
select * from dba_objects where owner='用户名' and object_name='序列名'; 如果返回为空,则表示没有该序列
from USER_OBJECTS WHERE OBJECT_TYPE='SEQUENCE' from user_sequences from dba_objects where owner='用户名' and object_name='序列名' from sys.all_objects where owner '用户名' and object_name='序列名' from sys.all_sequence where sequence_owner='用户名' and sequence_name='序列名' 等都可以判断,看情况选择使用了,当然,使用all_objects ,dba_objects 的速度比较慢,因为数据量很大,相比使用user_sequences 的速度就比较快了,其次是sys.all_sequence,USER_OBJECTS ,但涉及到user的都只是当前用户的,如果要查找全数据库还是使用:all_sequence 比较好些。
如果返回为空,则表示没有该序列
from user_sequences
from dba_objects where owner='用户名' and object_name='序列名'
from sys.all_objects where owner '用户名' and object_name='序列名'
from sys.all_sequence where sequence_owner='用户名' and sequence_name='序列名'
等都可以判断,看情况选择使用了,当然,使用all_objects ,dba_objects 的速度比较慢,因为数据量很大,相比使用user_sequences 的速度就比较快了,其次是sys.all_sequence,USER_OBJECTS ,但涉及到user的都只是当前用户的,如果要查找全数据库还是使用:all_sequence 比较好些。