1. .
1.
1. , , .. . .
3.3 ר
. :
- ;
- PL/SQL ;
- PL/SQL .
. .
1. ? .
2. ? .
3. .
4
. PL/SQL; (Package).
PL/SQL , . , , , .
: . : , , , , , . . :
PACKAGE emp_actions IS --
PROCEDURE hire_employee (empno NUMBER, ename CHAR,...);
PROCEDURE fire_employee (emp_id NUMBER);
END emp_actions;
PACKAGE BODY emp_actions IS --
PROCEDURE hire_employee (empno NUMBER, ename CHAR,...) IS
BEGIN
INSERT INTO emp VALUES (empno, ename,...);
END hire_employee;
PROCEDURE fire_employee (emp_id NUMBER) IS
BEGIN
DELETE FROM emp WHERE empno = emp_id;
END fire_employee;
END emp_actions;
. .
, ORACLE, . , . . , .
|
|
|
, , . , , , , , .
. , . . , raise-salary . , , , . raise-salary .
. , , . , , , , .
PL/SQL , , . , , . . , ( ), .
