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!

Need to check greater value in varchar column

sanJul 16 2018 — edited Jul 23 2018

Hi All,

I have a table column which contains the below values

Column A

-----------------

Good

120

140

Bad

Worst

1220

2220

Now I want to display this column value where ever the value is greater than 120 (in number) I need to display as 120+ .

I tried with case statement but getting invalid number error since this column having varchar values. How do achieve this?

Regards,

San

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2018

Added on Jul 16 2018

16 comments

1,248 views