HomeBlogAll quarters in current year in Oracle SQL ?Problem and SolutionsAll quarters in current year in Oracle SQL ?By M.K. Verma · 4 May 2022You can use a hierarchical query such as SELECT TO_CHAR(sysdate, 'yyyy" Q "')||level AS QuaterDate FROM dual CONNECT BY level <= 4 Share this:CommentsLeave a commentPost