오라클 공인교재용 SQL 샘플 DB 삭제 스크립트

REM Drop teach account

CONNECT &&user_name/&&user_password

DROP PROCEDURE add_job_history;

DROP PROCEDURE secure_dml;

DROP VIEW emp_details_view;

DROP SEQUIENCE departments_seq;

DROP SEQUIENCE employees_seq;

DROP SEQUIENCE locations_seq;

DROP TABLE regions   CASCADE CONSTRAINTS;

DROP TABLE departments   CASCADE CONSTRAINTS;

DROP TABLE locations   CASCADE CONSTRAINTS;

DROP TABLE locations   CASCADE CONSTRAINTS;

DROP TABLE jobs   CASCADE CONSTRAINTS;

DROP TABLE job_history   CASCADE CONSTRAINTS;

DROP TABLE employees   CASCADE CONSTRAINTS;

DROP TABLE countries   CASCADE CONSTRAINTS;

CONNECT system/manager

DROP USER &&user_name CASCADE;