Quick Inquiry

All quarters in current year in Oracle SQL ?

Yogesh Kumar
04-May-2022
0

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

18 0 7

Write a Comments

* Be the first to Make Comment

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online