Advertisement

TrimwebsolutionsTrimwebsolutions

Problem and Solutions

All quarters in current year in Oracle SQL ?

By M.K. Verma · 4 May 2022

All quarters in current year in Oracle SQL ?

You can use a hierarchical query such as

 SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuaterDate 
   FROM dual
CONNECT BY level <= 4