select * from t_grade
create table t_grade(
id number primary key not null,
gradeName varchar(33),
gradeDesc varchar(40)
)
delete from t_grade t where t.id=3
drop sequence sq
drop table t_grade
create sequence sq increment by 1 start with 1
select * from t_grade
insert into t_grade values(sq.nextval,'xx','xxxx');
insert into t_grade values(sq.nextval,'xx','xxxx');
insert into t_grade values(2,'xx','xxxx')
commit
create table t_grade(
id number primary key not null,
gradeName varchar(33),
gradeDesc varchar(40)
)
delete from t_grade t where t.id=3
drop sequence sq
drop table t_grade
create sequence sq increment by 1 start with 1
select * from t_grade
insert into t_grade values(sq.nextval,'xx','xxxx');
insert into t_grade values(sq.nextval,'xx','xxxx');
insert into t_grade values(2,'xx','xxxx')
commit