Could I get an output from Oracle Database from the following set of commands?

SET ECHO ON

DROP TABLE SYSTEM.DDI_CANCELLATIONS;

CREATE TABLE SYSTEM.DDI_CANCELLATIONS

(

REGID NUMBER(4),PATRONID NUMBER(5),ROOMNUM NUMBER(5),REGDATE DATE, UPDATE_BY VARCHAR2(10)

);

CREATE OR REPLACE TRIGGER DDI.SAVE_CANCELLATION

BEFORE UPDATE

ON DDI.REGISTRATIONS

FOR EACH ROW

DECLARE

v_Date DATE;

v_UserName VARCHAR2(10);

BEGIN

SELECT SYSDATE, USER

INTO v_Date, v_UserName

FROM DUAL;

INSERT INTO SYSTEM.DDI,CANCELLATIONS

(REGID, REGDATE, PATRONID, ROOMNUM)

VALUES

(:OLD.REGID, :REGDATE, :PATRONID, v_ROOMNUM;

END;

/

UPDATE DDI_CANCELLATIONS

SET REGID = 0

WHERE REGID = 45;

SELECT * FROM SYSTEM.DDI.REGISTRATIONS;

ROLLBACK;