-- SEQUENCE(시퀀스) 생성 create sequence jno_seqincrement by 1start with 100maxvalue 110minvalue 90cyclecache 2; -- SEQUENCE 생성 및 각종 옵션 테스트create table s_order(ord_no number(4),ord_name varchar2(10),p_name varchar2(20),p_qty number); insert into s_order values (jno_seq.NEXTVAL, 'James', 'apple', 5);insert into s_order values (jno_seq.NEXTVAL, 'Ford', 'berry', 3); select * from s_order; select jno_seq..