1.create table another_dept as
select * from scott.dept;
2.alter table another_dept
add constraint another_dept_pk
primary key(deptno);
3.create table another_emp as
select *
from scott.emp;
alter table another_emp
add constraint another_dept_fk
foreign key(deptno) references anther_dept(deptno);
4.PL/SQL 语言编写的主要不是客户端的程序,而是服务器的程序
DECLARE
说明部分
BEGIN
执行部分(程序主体)
EXCEPTION
例外处理部分
END;