By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TO_CHAR(TRUNC(SYSDATE-ROWNUM),'DD-MON') |
|---|
| 26-JAN |
| 25-JAN |
| 24-JAN |
| 23-JAN |
| 22-JAN |
| 21-JAN |
| 20-JAN |
| 19-JAN |
| 18-JAN |
| 17-JAN |
| 16-JAN |
| 15-JAN |
| 14-JAN |
| 13-JAN |
| 12-JAN |
| 11-JAN |
| 10-JAN |
| 09-JAN |
| 08-JAN |
| 07-JAN |
| 06-JAN |
| 05-JAN |
| 04-JAN |
| 03-JAN |
| 02-JAN |
| 01-JAN |
| 31-DEC |
| 30-DEC |
| 29-DEC |
| 28-DEC |
| 27-DEC |
| 26-DEC |
| 25-DEC |
| 24-DEC |
| 23-DEC |
| 22-DEC |
| 21-DEC |
| 20-DEC |
| 19-DEC |
| 18-DEC |
| 17-DEC |
| 16-DEC |
| 15-DEC |
| 14-DEC |
| 13-DEC |
| 12-DEC |
| 11-DEC |
| 10-DEC |
| 09-DEC |
| 08-DEC |
| 07-DEC |
| 06-DEC |
| 05-DEC |
| 04-DEC |
| 03-DEC |
| 02-DEC |
| 01-DEC |
| 30-NOV |
| 29-NOV |
| 28-NOV |
| 27-NOV |
| 26-NOV |
| 25-NOV |
| 24-NOV |
| 23-NOV |
| 22-NOV |
| 21-NOV |
| 20-NOV |
| 19-NOV |
| 18-NOV |
| 17-NOV |
| 16-NOV |
| 15-NOV |
| 14-NOV |
| 13-NOV |
| 12-NOV |
| 11-NOV |
| 10-NOV |
| 09-NOV |
| 08-NOV |
| 07-NOV |
| 06-NOV |
| 05-NOV |
| 04-NOV |
| 03-NOV |
| 02-NOV |
| 01-NOV |
| 31-OCT |
| 30-OCT |
| 29-OCT |
| 28-OCT |
| 27-OCT |
| 26-OCT |
| 25-OCT |
| 24-OCT |
| 23-OCT |
| 22-OCT |
| 21-OCT |
| 20-OCT |
| 19-OCT |
| 18-OCT |
| 17-OCT |
| 16-OCT |
| 15-OCT |
| 14-OCT |
| 13-OCT |
| 12-OCT |
| 11-OCT |
| 10-OCT |
| 09-OCT |
| 08-OCT |
| 07-OCT |
| 06-OCT |
| 05-OCT |
| 04-OCT |
| 03-OCT |
| 02-OCT |
| 01-OCT |
| 30-SEP |
| 29-SEP |
| 28-SEP |
| 27-SEP |
| 26-SEP |
| 25-SEP |
| 24-SEP |
| 23-SEP |
| 22-SEP |
| 21-SEP |
| 20-SEP |
| 19-SEP |
| 18-SEP |
| 17-SEP |
| 16-SEP |
| 15-SEP |
| 14-SEP |
| 13-SEP |
| 12-SEP |
| 11-SEP |
| 10-SEP |
| 09-SEP |
| 08-SEP |
| 07-SEP |
| 06-SEP |
| 05-SEP |
| 04-SEP |
| 03-SEP |
| 02-SEP |
| 01-SEP |
| 31-AUG |
| 30-AUG |
| 29-AUG |
| 28-AUG |
| 27-AUG |
| 26-AUG |
| 25-AUG |
| 24-AUG |
| 23-AUG |
| 22-AUG |
| 21-AUG |
| 20-AUG |
| 19-AUG |
| 18-AUG |
| 17-AUG |
| 16-AUG |
| 15-AUG |
| 14-AUG |
| 13-AUG |
| 12-AUG |
| 11-AUG |
| 10-AUG |
| 09-AUG |
| 08-AUG |
| 07-AUG |
| 06-AUG |
| 05-AUG |
| 04-AUG |
| 03-AUG |
| 02-AUG |
| 01-AUG |
| 31-JUL |
| 30-JUL |
| 29-JUL |
| 28-JUL |
| 27-JUL |
| 26-JUL |
| 25-JUL |
| 24-JUL |
| 23-JUL |
| 22-JUL |
| 21-JUL |
| 20-JUL |
| 19-JUL |
| 18-JUL |
| 17-JUL |
| 16-JUL |
| 15-JUL |
| 14-JUL |
| 13-JUL |
| 12-JUL |
| 11-JUL |
| 10-JUL |
| 09-JUL |
| 08-JUL |
| 07-JUL |
| 06-JUL |
| 05-JUL |
| 04-JUL |
| 03-JUL |
| 02-JUL |
| 01-JUL |
| 30-JUN |
| 29-JUN |
| 28-JUN |
| 27-JUN |
| 26-JUN |
| 25-JUN |
| 24-JUN |
| 23-JUN |
| 22-JUN |
| 21-JUN |
| 20-JUN |
| 19-JUN |
| 18-JUN |
| 17-JUN |
| 16-JUN |
| 15-JUN |
| 14-JUN |
| 13-JUN |
| 12-JUN |
| 11-JUN |
| 10-JUN |
| 09-JUN |
| 08-JUN |
| 07-JUN |
| 06-JUN |
| 05-JUN |
| 04-JUN |
| 03-JUN |
| 02-JUN |
| 01-JUN |
| 31-MAY |
| 30-MAY |
| 29-MAY |
| 28-MAY |
| 27-MAY |
| 26-MAY |
| 25-MAY |
| 24-MAY |
| 23-MAY |
| 22-MAY |
| 21-MAY |
| 20-MAY |
| 19-MAY |
| 18-MAY |
| 17-MAY |
| 16-MAY |
| 15-MAY |
| 14-MAY |
| 13-MAY |
| 12-MAY |
| 11-MAY |
| 10-MAY |
| 09-MAY |
| 08-MAY |
| 07-MAY |
| 06-MAY |
| 05-MAY |
| 04-MAY |
| 03-MAY |
| 02-MAY |
| 01-MAY |
| 30-APR |
| 29-APR |
| 28-APR |
| 27-APR |
| 26-APR |
| 25-APR |
| 24-APR |
| 23-APR |
| 22-APR |
| 21-APR |
| 20-APR |
| 19-APR |
| 18-APR |
| 17-APR |
| 16-APR |
| 15-APR |
| 14-APR |
| 13-APR |
| 12-APR |
| 11-APR |
| 10-APR |
| 09-APR |
| 08-APR |
| 07-APR |
| 06-APR |
| 05-APR |
| 04-APR |
| 03-APR |
| 02-APR |
| 01-APR |
| 31-MAR |
| 30-MAR |
| 29-MAR |
| 28-MAR |
| 27-MAR |
| 26-MAR |
| 25-MAR |
| 24-MAR |
| 23-MAR |
| 22-MAR |
| 21-MAR |
| 20-MAR |
| 19-MAR |
| 18-MAR |
| 17-MAR |
| 16-MAR |
| 15-MAR |
| 14-MAR |
| 13-MAR |
| 12-MAR |
| 11-MAR |
| 10-MAR |
| 09-MAR |
| 08-MAR |
| 07-MAR |
| 06-MAR |
| 05-MAR |
| 04-MAR |
| 03-MAR |
| 02-MAR |
| 01-MAR |
| 29-FEB |
| 28-FEB |
| 27-FEB |
| 26-FEB |
| 25-FEB |
| 24-FEB |
| 23-FEB |
| 22-FEB |
| 21-FEB |
| 20-FEB |
| 19-FEB |
| 18-FEB |
| 17-FEB |
| 16-FEB |
| 15-FEB |
| 14-FEB |
| 13-FEB |
| 12-FEB |
| 11-FEB |
| 10-FEB |
| 09-FEB |
| 08-FEB |
| 07-FEB |
| 06-FEB |
| 05-FEB |
| 04-FEB |
| 03-FEB |
| 02-FEB |
| 01-FEB |
| 31-JAN |
| 30-JAN |
| 29-JAN |
| 28-JAN |