APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select column based on conditions

2796536Nov 17 2014 — edited Nov 18 2014

Hi,

I have 26 columns with name as COMPLIANCE_ITEM_1 to COMPLIANCE_ITEM_26. The data stored in this column is Yes or No, in format of 1 or 0. Now, I need to write a select query with below condition,

Give output of those column only which are set to 1.

So I have different column Region, Country, Compliance_ITEM_1 .... Compliance_Item_26 from table1.

based on the user input it should display those compliance item column which are set to 1.

How it can be achieved?

Thanks

Nikhil Sanghvi

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2014

Added on Nov 17 2014

#apex-discussions, #column

5 comments

1,744 views