 |
 |
Archives of the TeradataForum
Message Posted: Mon, 07 Mar 2005 @ 16:09:59 GMT
| Subj: | | Re: Extracting names from a CLOB column |
| |
| From: | | Victor Sokovin |
| | My client wants to investigate possible ways to search a text document stored in a CLOB column and extract the names of people that appear
in it into a VARCHAR column. Has anyone had any experience implementing such an application using a UDF, text mining or other software? | |
Other software. Namely, Oracle OWA_PATTERN package. It seems to be doing the job and offers all usual search and replace functionality based on
regular expressions. I had no problems with it on small volumes but still have to see how it behaves when volumes increase.
Regards,
Victor
| |
