student.sql

关于使用ORCLE数据库的例子

prompt PL/SQL Developer import file
prompt Created on 2005年11月17日 by sc_admin
set feedback off
set define off
prompt Disabling triggers for STUDENT...
alter table STUDENT disable all triggers;
prompt Disabling foreign key constraints for STUDENT...
alter table STUDENT disable constraint DEPTNUMJBER;
prompt Deleting STUDENT...
delete from STUDENT;
commit;
prompt Loading STUDENT...
prompt Table is empty
prompt Enabling foreign key constraints for STUDENT...
alter table STUDENT enable constraint DEPTNUMJBER;
prompt Enabling triggers for STUDENT...
alter table STUDENT enable all triggers;
set feedback on
set define on
prompt Done.