Sequence operations in Oracle and prior sequence Initialization

Sequence operations in Oracle and use the previous initialization of sequence 1 create sequence myseqstart with 1 increment by 1 nomaxvalueminvalue 1 II Initialize sequence select myseq. nextval from dual; it is worth noting that if you write select myseq directly first. currval from dual, will prompt myseq. currtval has not been defined in this session. Www.2cto.com 3 can be used only after the sequence is initialized. We use ibatis as an example. <Insert id = "insert" parameterClass = "Student"> <selectKey resultClass = "String" keyProperty = "mid"> select myseq. nextval from dual </selectKey> <! [CDATA [insert into Student (id, name, age) values (# mid #, # mname #, # mage #)]> </insert> www.2cto.com when you modify a sequence, you cannot modify the following values: 1. You cannot modify the initial value of the sequence. 2. The minimum value of the sequence cannot be greater than the current value (currval) 3. the maximum value of the sequence cannot be smaller than the current value (currval) alter sequence myseqincrement by 2. Five. Delete the sequence drop sequence myseq author woshixuye.