SELECT date111
FROM (SELECT TO_DATE (LPAD (ROWNUM, 2, 0) || '012021', 'ddmmrrrr') date111
FROM emp
WHERE ROWNUM <= 31)
WHERE TRIM (TO_CHAR (date111, 'Day')) = 'Friday'
No comments:
Post a Comment