<div>
you can't have a dynamic number of columns,<br />
<br />
that is, if an extra row &quot;40&quot; shows up, a sql query won't automatically create a 4th column for you.<br />
<br />
but for a static set of columns, simply number them and then use conditional aggregates to pivot<br />
<br />
SELECT MAX(CASE WHEN rn = 1 THEN deptno END) dept1,<br />
&nbsp; &nbsp; &nbsp; &nbsp;MAX(CASE WHEN rn = 2 THEN deptno END) dept2,<br />
&nbsp; &nbsp; &nbsp; &nbsp;MAX(CASE WHEN rn = 3 THEN deptno END) dept3<br />
&nbsp; FROM (SELECT deptno, ROW_NUMBER() OVER (ORDER BY deptno) rn FROM dept);
</div>


<div>
it is static only for 3 rows
</div>


<div>
<div class="content wysiwyg-content">
I have a requirement as follows eg <br />
to get in a single row in 3 different columns. i will use this query in oracle report<br />
<br />
dept no<br />
10<br />
20<br />
30<br />
<br />
as <br />
dept1 dept2 dept3<br />
10 &nbsp; &nbsp; &nbsp; 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<br />
<br />
thanks
</div>
</div>


I have a requirement as follows eg 
to get in a single row in 3 different columns. i will use this query in oracle report

dept no
10
20
30

as 
dept1 dept2 dept3
10       20          30

thanks

oracle query

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.