report_card.sql

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

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 REPORT_CARD...
alter table REPORT_CARD disable all triggers;
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 Loading REPORT_CARD...
prompt Table is empty
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 REPORT_CARD...
alter table REPORT_CARD enable all triggers;
set feedback on
set define on
prompt Done.