1. : ID_CRE ( varchar2) DAT_CRE ( date). . , . : FOR EACH ROW , . (), , , , WHEN. , , ().
BEGIN DECLARE, ( Oracle). .
2. BEGIN END NULL; PL/SQL, . , STUDENT. , S_STUDENT. PL/SQL, , :
select S_STUDENT.nextval into:new.STUDENT_ID from dual;
:new.ID_CRE:=user;
:new.DAT_CRE:=sysdate;
, S_STUDENT. NEXTVAL dual , Select.
NEW ( ), , , .
USER , .
SYSDATE , .
, () , ( Insert)!
3. : (Ctrl+Shift+F9) . . Triggers .
4. . , , . , (Insert) (Update). ID_CRE DAT_CRE.
4. .