序列脚本

51Testing软件测试网2Oia` `'{
1、删除已经存在的myseq序列:
/d [ Tf!hg0drop sequence myseq;51Testing软件测试网8b\x`j!x

创建一个在1--10之间幅度为2的循环序列：51Testing软件测试网-v+@7sVD;[N
create sequence myseq
I^1?[r ^k0   maxvalue 1051Testing软件测试网$E_0M:]u
   start with 1
PQ\OCe1t-A
|^0   increment by 251Testing软件测试网2?F9f?Z`/y0R~
   cache 2
A8L*}7iQk$P?}0   cycle;51Testing软件测试网%t.G$V'KHG

[ a,t#I1Vn M*n03、创建测试表：
^{Qjw$Xw/S0create table testseq(next   number,51Testing软件测试网x,?(w9a*Qc2aK
       curr  number);
@Yd9z3{FvHy04、插入测试数据：
3c q,R2~2O@&zBn!O.C4TN0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);51Testing软件测试网u-]tT-g0X
insert into testseq(next,curr) values(myseq.nextval,myseq.currval);
&xrHr
];[/|.~1lQo8s0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);
0@xl9Fv3FM9j0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);51Testing软件测试网`;S'F#Uc)t
insert into testseq(next,curr) values(myseq.nextval,myseq.currval);
'h"y-je+Qmj(F0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);51Testing软件测试网0d.Rs!m/M LJ
insert into testseq(next,curr) values(myseq.nextval,myseq.currval);
,e/NX-?#SlX"G0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);
-~qgmkcD0insert into testseq(next,curr) values(myseq.nextval,myseq.currval);51Testing软件测试网+H8`S k `4p6?#wB
5、查询表数据：51Testing软件测试网H BaiU$Cl:CG(l\

select * from testseq;
w"Fc&?.v&bp0结果:在附件中        

搜狗浏览器截图(1)