?? experimentes4.sql
字號:
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.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -