BEGIN
EXECUTE IMMEDIATE 'DROP SEQUENCE SEQ_SYS_ID';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -2289 THEN
RAISE;
END IF;
END;
/
CREATE SEQUENCE SEQ_SYS_ID
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999
CACHE 1000
CYCLE
NOORDER;
SELECT my_table_S.CURRVAL FROM DUAL;
SELECT my_table_S.NEXTVAL FROM DUAL;
ALTER SEQUENCE my_table_S INCREMENT BY 100;
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE my_table';
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -942 THEN
RAISE;
END IF;
END;
/
alter table student add(grade number(3) default '' not null) ;
alter table student modify(grade varchar2(5));
alter table student drop (grade);
alter table student rename column grade to grade_tmp;
alter table student add grade number(3);
update student set grade=trim(grade_tmp);
alter table student drop column grade_tmp;