SQLPLUS,基本SQL.pptVIP

* grant create sequence to courseadmin; * create sequence myseq start with 20 increment by 1 maxvalue 9999999 minvalue 1 cache 5 nocycle order;//按顺序产生序列 * select myseq.nextval from dual; select myseq. currval from dual; * SQL insert into courses values(c003ded8,oracle,ql407,T002145,myseq.nextval); 已创建 1 行。 SQL select * from courses; SQL drop sequence myseq; 序列已删除。 COID CONAME COADDRESS COTEACHE COHOUR CO154 刑法通则 3#教学楼205 T002065 45 C2054 网络安全 3#教学楼502 T003254 32 C0025 C+