oracle_DBA_临时表_约束_oracle 临时表约束-优快云博客

本文通过实例演示了如何在Oracle数据库中使用序列进行增删改查等基本操作，并展示了序列的相关属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.序列方法：

==序列已创建的方法，CRUD

SQL> create sequence s8;

序列已创建。

SQL> select s8.nextval from dual;

NEXTVAL
----------
1

SQL> select s8.nextval from dual;

NEXTVAL
----------
2

SQL> select s8.nextval from dual;

NEXTVAL
----------
3

SQL> --查询默认数值
SQL> --切换到sys
SQL> show user;
USER 为 "SYS"
SQL> conn scott/tiger;
已连接。
SQL> --创建序列

SQL> create sequence s9;

序列已创建。

SQL> select * from user_seqence where sequence='S9';

SQL> select * from user_sequence where sequence_name='S9';
select * from user_sequence where sequence_name='S9'
*

SQL> select * from user_sequences where SEQUENCE_NAME='S9';

SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE
------------------------------ ---------- ---------- ------------ - - ----------
LAST_NUMBER
-----------
S9 1 1.0000E+28 1 N N 20
1


SQL> set lines 200
SQL> select * from user_sequences where SEQUENCE_NAME='S9'
2 /

SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
S9 1 1.0000E+28 1 N N 20 1