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!

How to update clob data with default value

User_2IZ8USep 21 2019 — edited Oct 21 2019

Hi all,

Good day

I want to  know how to update a clob datatype with the default value.

Actually I have table with userid   and  role defined in the clob. This  differs from user id . I want to update all my users with one default value. How can I achieve this ?.

Any thoughts or idea?

Thanks in advance.

Sri
Comments
Post Details
Added on Sep 21 2019
10 comments
2,181 views