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!

How to Read Specific word from MS word Tabular format data stored in CLOB column on Oracle Database?

iyappansMar 11 2024 — edited Mar 12 2024

Hi Friends,

We have a MS word document with the Version details as given below, and the same has been loaded into the Oracle Database in CLOB format. As we know, when we load the tabular data into CLOB format, the same MS format will not be retained. We have a requirement to extract the latest author name from the table as shown above.

We have thousands of such MS documents, and we need to identify the author names, Kindly advise how we can achieve to read the author name dynamically from the table which is stored in CLOB column in database or from the File directly.

I appreciate if anyone give your suggestions or help in this regard.

Thank you so much!

Iyappan

Sample Tabular Form Data of MS WOrd Document.PNG

Comments
Post Details
Added on Mar 11 2024
5 comments
135 views