Oracle region settings

Affecting default date string, number representation

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR';

DECLARE
    testdate   DATE;
BEGIN
    SELECT '20230306' INTO testdate FROM DUAL;

    DBMS_OUTPUT.put_line (testdate);
END;

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

DECLARE
    testdate   DATE;
BEGIN
    SELECT '20230306' INTO testdate FROM DUAL;

    DBMS_OUTPUT.put_line (testdate);
END;