Skip to Main Content

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!

Want to replace values in result set

937193Jul 4 2012 — edited Jul 4 2012
Hi All,

I want to replace all the values in the result set of my query for one column as some string, how do i do that?

1. My query reults in Column A and Column B
2. Column A (Number - Data type)
3. Column B (Varchar - Data type)
4. Now I want to replace any value in column A as some text when it is not null, same for column B

Appreciate your inputs.

Thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2012
Added on Jul 4 2012
2 comments
445 views