Oracle Database Discussions

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!

remove value from a column

Pratap DalaiJul 17 2019 — edited Jul 18 2019

HI All,

I have table table user,which has has column permisssion

This column contins value like ;10000;0;100023;

I want to remove the ;0; from this column value and keep other values in that columns

There are 76000+ rows i needs to do the correction.

Please suggest how to do this

Added on Jul 17 2019

#general-database-discussions

13 comments

798 views