clase 1712
If you can't read please download the document
DESCRIPTION
sabdTRANSCRIPT
create table log_dpto(dptonro number(4), DNOMBRE VARCHAR2(20), LOCAL VARCHAR2(20), USUARIO VARCHAR2(20), FECHAHORA DATE);CREATE OR REPLACE TRIGGER LOG_DPTO_INS AFTER INSERT ON DPTO FOR EACH ROWBEGIN INSERT INTO LOG_DPTO VALUES (:NEW.DPTO, :NEW.DNAME,NEW.LOC, USER,SYSDATE); DBMS_OUTPUT.PUT_LINE('INSERTAMOS UN REGISTRO'); END; CREATE TABLE DPTO (DPTO NUMBER(4),DNAME VARCHAR2(20),LOC VARCHAR2(20)); INSERT INTO DPTO VALUES(1240,'XXXXXX','PIURA'); SELECT * FROM log_DPTO; CREATE OR REPLACE TRIGGER LOG_DPTO_INS AFTER INSERT ON DPTO FOR EACH ROWBEGIN INSERT INTO LOG_DPTO (DPTONRO,DNOMBRE,LOCAL,USUARIO,FECHAHORA) VALUES(NEW.DPTO,NEW.DNAME,NEW.LOC,USER,SYSDATE); DBMS_OUTPUT.PUT_LINE('INSERTAMOS UN REGISTRO');END;create table estudiante(idestudiante number(4), ape_pat varchar2(20), ape_mat varchar2(20), nombre varchar2(20), Nombre_completo varchar(60)); insert into estudiante (idestudiante,ape_pat,ape_mat,nombre) values(15,'perz','cruz','juan'); select * from estudiante; update estudiante set ape_pat='Perez' where idestudiante=15;CREATE OR REPLACE TRIGGER REGNOMCOM before INSERT OR UPDATE ON ESTUDIANTEfor each rowBEGIN :new.Nombre_completo:=concat(:new.ape_pat,concat(:new.ape_mat,:new.nombre));END;CREATE OR REPLACE TRIGGER LOG_DPTO_INS AFTER INSERT ON DPTO FOR EACH ROWBEGIN INSERT INTO LOG_DPTO VALUES(:NEW.DPTO,:NEW.DNAME,:NEW.LOC,USER,SYSDATE); DBMS_OUTPUT.PUT_LINE('INSERTAMOS UN REGISTRO');END;