<div>
&gt;&gt;only the columns with Y should come for each row<br />
<br />
I do not understand. &nbsp;Please post expected results for what you mean.
</div>


<div>
For first row<br />
<br />
&nbsp;empNO &nbsp;col1 &nbsp;col2 &nbsp;col3 &nbsp;col4 &nbsp;col5 &nbsp;col6 &nbsp;col7 &nbsp; col8 &nbsp; col9<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; Y<br />
query to get only &nbsp;<br />
<br />
&nbsp;col1 &nbsp;col2 &nbsp;col3 &nbsp;col6 &nbsp;col8 &nbsp; &nbsp;col9<br />
Y &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y
</div>


<div>
as I stated in the first post - you can't do that.<br />
<br />
SQL queries don't work like that<br />
<br />
<br />
you could execute 2 queries, first, find all columns that have at least one &quot;Y&quot; in them.<br />
<br />
Then using those results, construct a new query on the fly and then execute that query.<br />
This is called dynamic sql and it's generally an expensive operation and likely NOT what you really want as a production solution.<br />
<br />
Instead, I would recommend querying all of the columns and then either ignoring the N results, which you would have to do anyway.<br />
Or use reporting tools to hide/display columns as needed from the results.<br />
<br />
But, even in the case of a reporting tool. &nbsp;What you are asking for doesn't really make sense.<br />
<br />
If I have id 1, &nbsp;col1 Y, col2 N<br />
&nbsp;and id 2, col1 N, col2 Y.<br />
<br />
What should the output be? &nbsp;If I only return Y results, I'll get this...<br />
<br />
1, Y<br />
2, Y<br />
<br />
&nbsp;How does that make any sense or represent any useful information?
</div>


<div>
&gt;&gt;For first row<br />
<br />
Think about what you are asking.<br />
<br />
If row 1 returns 6 columns, what does row 2 return?<br />
<br />
How do you know the first value from the second column is col2 or col3?
</div>


<div>
sdstuber is correct.<br />
<br />
To add to my previous post, given your expected results for row 1, here is what it would look like for all 5 rows:<br />

<pre><code class="code-1 nolinks" id="code-20-41454845-1"><span>1 Y Y Y Y Y Y</span>
<span>2 Y Y Y Y Y</span>
<span>3 Y Y Y Y Y Y</span>
<span>4 Y Y Y Y</span>
<span>5 Y Y Y Y Y Y</span>
</code></pre>
<br />
There is no way to know which value came from which column.
</div>


<div>
If you don't really need columns you just need a flag list without details (since details won't be decipherable anyway as shown above) &nbsp;then you can try simple concatenation<br />
<br />
<br />
SELECT empno,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NULLIF(col1, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col2, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col3, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col4, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col5, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col6, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col7, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col8, 'N')<br />
&nbsp; &nbsp; &nbsp; &nbsp;|| NULLIF(col9, 'N') &nbsp;flags<br />
&nbsp; FROM yourtable
</div>


<div>
I've requested that this question be deleted for the following reason:<br />
<br />
this is not logical question so i am removing this question
</div>


<div>
The question is logical.<br />
<br />
Just because the &quot;you can't do it&quot; is the answer, doesn't invalidate it.<br />
<br />
Plus you have alternatives illustrated above
</div>


<div>
The first post answers the question with &quot;you can't do that&quot;<br />
<a href="http:#41454792" rel="ugc">http:#41454792</a>&nbsp;<br />
<br />
This post offers an alternative that might work for a text-based bar chart of sorts.<br />
It's not a general purpose solution, but can work for some types of usage.<br />
<br />
<a href="http:#41454894" rel="ugc">http:#41454894</a>
</div>


<div>
<div class="content wysiwyg-content">
i have multiple columns in table with Y or N value.<br />
i want to reture only Y value colmuns how can I do in a query<br />
<br />
ex data<br />
<br />
empNO &nbsp;col1 &nbsp;col2 &nbsp;col3 &nbsp;col4 &nbsp;col5 &nbsp;col6 &nbsp;col7 &nbsp; col8 &nbsp; col9<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; Y<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp; &nbsp; N &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp;N<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; N &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; Y<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; N &nbsp; &nbsp; &nbsp; N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; N<br />
5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp;N &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; Y<br />
<br />
only the columns with Y should come for each row<br />
thanks.
</div>
</div>


i have multiple columns in table with Y or N value.
i want to reture only Y value colmuns how can I do in a query

ex data

empNO  col1  col2  col3  col4  col5  col6  col7   col8   col9
1               Y          Y      Y      N      N        Y      N       Y         Y
2               N          Y      Y     Y        Y         N      N       Y        N
3               Y         N     Y      N         Y        Y      N       Y         Y
4               Y          Y    N       Y          N     N       N       Y         N
5               Y          Y      Y      N        N        Y      N       Y         Y

only the columns with Y should come for each row
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.