All quarters in current year in Oracle SQL ?

• Yogesh Kumar
• 04-May-2022
• 0

You can use a hierarchical query such as

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

* Be the first to Make Comment