--- 查询语句
select 'create sequence SYSTEM.'|| SEQUENCE_NAME || ' minvalue '||MIN_VALUE||' maxvalue '||MAX_VALUE||' start with '||LAST_NUMBER||' increment by '||INCREMENT_BY||' cache '||CACHE_SIZE||' ;'
from dba_sequences where SEQUENCE_OWNER='SYSTEM';
---- 分组查询序列拥有人
select ds.sequence_owner from dba_sequences ds group by ds.sequence_owner;
---- 创建序列
create sequence SYSTEM.SEQ0001T minvalue 1 maxvalue 9999999999999999999 start with 1 increment by 1 cache 20 ;
阅读(4705) | 评论(0) | 转发(0) |