alexa
Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
Quick Inquiry

All quarters in current year in Oracle SQL ?

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

GoodFirms Badge
GoodFirms Badge

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