YGBH char(6) primary key, --員工編號，主鍵，格式：YYxxxx YY年2位 xxxx流水
YGXM varchar2(8), --員工姓名
YGXB char(1) CHECK (ygxb IN ('M','W')), --員工性別,男=M 女=W
CSRQ char(8)); --出生日期,格式：YYYYMMDD
1、存儲過程
create or replace procedure P_insert(
v_ygbh IN varchar2,
v_ygxm IN varchar2,
v_ygxb IN varchar2,
v_csrq IN varchar2) is
begin
INSERT INTO t_ygxxb values(v_ygbh,v_ygxm,v_ygxb,v_csrq);
COMMIT;
end P_insert;
調用：BEGIN p_insert('130001','曹操','M','01550101'); END;
2、Select * from t_ygxxb where ygbh='&bh';
3、函數
create or replace function F_max(i in int,j in int,k IN INT) return integer is
Result integer;
begin
if i>=j then
IF i>=k THEN Result:=i;
ELSE Result:=k;
END IF;
ELSE
IF j>=k THEN Result:=j;
ELSE Result:=k;
END IF;
end if;
return(Result);
end F_max;
調用：BEGIN dbms_output.put_line(f_max(5,6,7)); END;
4、函數
create or replace function F_name(v_ygbh varchar2) return varchar2 is
v_name VARCHAR2(8);
begin
SELECT ygxm INTO v_name FROM t_ygxxb WHERE ygbh=v_ygbh;
return(v_name);
end F_name;
調用：BEGIN dbms_output.put_line(f_name('130001')); END;