<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
How to display current quarter and four future quarters using sysdate??<br />
<br />
select 'Q'||to_char(sysdate,'Q')|<wbr />|'-'||to_c<wbr />har(sysdat<wbr />e,'YYYY') from dual;<br />
Q4-2007<br />
I want to generate the following:<br />
Q4-2007<br />
Q1-2008<br />
Q2-2008<br />
Q3-2008<br />
Q4-2008<br />
Thanks,<br />

</div>
</div>


Hello Experts,

How to display current quarter and four future quarters using sysdate??

select 'Q'||to_char(sysdate,'Q')||'-'||to_char(sysdate,'YYYY') from dual;
Q4-2007
I want to generate the following:
Q4-2007
Q1-2008
Q2-2008
Q3-2008
Q4-2008
Thanks,


current quarter and four future quarters

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.