create_data.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 45 行

create table emp(
empno  number(8),
ename  varchar2(10),
job    varchar2(10),
sal    number(8,2),
deptno number(3));

create table dept(
deptno number(3),
dname  varchar2(10));

insert into emp values(1,'shi','hunter',100,1);

insert into emp values(2,'Jack','hunter',100,1);

insert into dept values(1,'hunters');


----table oracle provided-----
CREATE TABLE DEPT
    (DEPTNO    NUMBER(2) NOT NULL,
     DNAME     VARCHAR2(14),
     LOC       VARCHAR2(13))

CREATE TABLE EMP
    (EMPNO     NUMBER(4) NOT NULL,
     ENAME     VARCHAR2(10),
     JOB       VARCHAR2(9),
     MGR       NUMBER(4),
     HIREDATE  DATE,
     SAL       NUMBER(7,2),
     COMM      NUMBER(7,2),
     DEPTNO    NUMBER(2));


--建立一个存储过程----
create or replace procedure count_emp(

emp_num out number) is 
begin
	select count(*) into emp_num from emp;
end;