DECLARE
V1 VARCHAR2(10);
BEGIN
SELECT TO_CHAR(SYSDATE, 'YYYYYMMDD') INTO V1 FROM dual ;
DBMS_OUTPUT.PUT_LINE('----------------- ' || V1);
END;
DECLARE
V1 VARCHAR2(10);
BEGIN
SELECT TO_CHAR(SYSDATE, 'YYYYYMMDD') INTO V1 FROM dual ;
DBMS_OUTPUT.PUT_LINE('----------------- ' || V1);
END;