experimentes4.sql

来自「使用ORCLE创建表」· SQL 代码 · 共 54 行

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 COURSES...
alter table COURSES disable all triggers;
prompt Disabling triggers for DEPT...
alter table DEPT disable all triggers;
prompt Disabling triggers for STUDENT...
alter table STUDENT disable all triggers;
prompt Disabling triggers for REPORT_CARD...
alter table REPORT_CARD disable all triggers;
prompt Disabling foreign key constraints for STUDENT...
alter table STUDENT disable constraint DEPTNUMJBER;
prompt Disabling foreign key constraints for REPORT_CARD...
alter table REPORT_CARD disable constraint COURSENUMBER;
alter table REPORT_CARD disable constraint STUDNETNUMBER;
prompt Deleting REPORT_CARD...
delete from REPORT_CARD;
commit;
prompt Deleting STUDENT...
delete from STUDENT;
commit;
prompt Deleting DEPT...
delete from DEPT;
commit;
prompt Deleting COURSES...
delete from COURSES;
commit;
prompt Loading COURSES...
prompt Table is empty
prompt Loading DEPT...
prompt Table is empty
prompt Loading STUDENT...
prompt Table is empty
prompt Loading REPORT_CARD...
prompt Table is empty
prompt Enabling foreign key constraints for STUDENT...
alter table STUDENT enable constraint DEPTNUMJBER;
prompt Enabling foreign key constraints for REPORT_CARD...
alter table REPORT_CARD enable constraint COURSENUMBER;
alter table REPORT_CARD enable constraint STUDNETNUMBER;
prompt Enabling triggers for COURSES...
alter table COURSES enable all triggers;
prompt Enabling triggers for DEPT...
alter table DEPT enable all triggers;
prompt Enabling triggers for STUDENT...
alter table STUDENT enable all triggers;
prompt Enabling triggers for REPORT_CARD...
alter table REPORT_CARD enable all triggers;
set feedback on
set define on
prompt Done.