Problem and Solutions
All quarters in current year in Oracle SQL ?
By M.K. Verma · 4 May 2022

You can use a hierarchical query such as
SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuaterDate
FROM dual
CONNECT BY level <= 4 Advertisement
Problem and Solutions
By M.K. Verma · 4 May 2022

You can use a hierarchical query such as
SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuaterDate
FROM dual
CONNECT BY level <= 4