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!

Regular Expression and Random Chars string

User_CS62GJan 17 2020 — edited Jan 20 2020

Hello Team,

I have a CLOB column in a table which could contain multiple lines of data or a paragraph of data as below. We have to treat each line and change each word into random characters as below.

                                   Before                                                                                                                                            After

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

He is a boy.                                                                                                                                               Pt ot s yus.

His name is Rama.                                                                                                                                   Skl eypt es awkt.

This is dummy data. Any value can be inserted.No guarantee of                                                           dfsd io pofty gher. pio lopuy rty .............(random characters)

values.

(This is a paragraph with only 1 enter.)

Every word should be of equal length of word in input lines.

Please help me with an idea how to implement it.

Comments
Post Details
Added on Jan 17 2020
3 comments
277 views