Skip to Main Content
Forums

SQL & PL/SQL

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!

Merge two column value in single column

973311Jan 20 2014 — edited Jan 21 2014

Team,

I have a requirement where in I need to merge 2 column values in a single column.

ex. I have Percent_complete column in my table. and my table has only one record.

I need to query such that I need to store the values of percent_complete and (100- percent_complete) values in a single column.

ex

Percent complete has 30 value.

I need to select 30 and 70(100-30) both in a single column.

Thanks,
This post has been answered by BluShadow on Jan 20 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2014
Added on Jan 20 2014
12 comments
1,620 views