Oracle, Clob to table

Clob to table

Author	Message
Clayt #1 / 4	Clob to table Is there any way to convert a clob to a searchable/sortable table? I have clob data that I need to sort and search. I would rather not do it programmatically. So, I was hoping that someone knows of a way to do this using Oracle built in functions. Thank you Clayton Webb
Mon, 21 Feb 2005 06:00:43 GMT

Daniel Morga #2 / 4	Clob to table Quote: > Is there any way to convert a clob to a searchable/sortable table? > I have clob data that I need to sort and search. I would rather not > do it programmatically. So, I was hoping that someone knows of a way > to do this using Oracle built in functions. > Thank you > Clayton Webb Can you perhaps provide a bit more information so that someone might attempt to help you. Lets start with the basics. Stuff like version and edition of Oracle. Number of records. Size of the CLOBs. You know ... useful stuff. Daniel Morgan
Mon, 21 Feb 2005 06:10:00 GMT

Vladimir M. Zakharyche #3 / 4	Clob to table What kind of data are you storing in CLOBs? XML? Then look at XDK. Textual? Then interMedia Text/Oracle Text may be of help. Spreadsheets? I doubt there is a simple way of working with them as with structured data while storing them as unstructured data (which CLOBs represent). -- Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. Quote: > Is there any way to convert a clob to a searchable/sortable table? > I have clob data that I need to sort and search. I would rather not > do it programmatically. So, I was hoping that someone knows of a way > to do this using Oracle built in functions. > Thank you > Clayton Webb
Mon, 21 Feb 2005 13:16:17 GMT

Clayt #4 / 4	Clob to table Quote: > > Is there any way to convert a clob to a searchable/sortable table? > > I have clob data that I need to sort and search. I would rather not > > do it programmatically. So, I was hoping that someone knows of a way > > to do this using Oracle built in functions. > > Thank you > > Clayton Webb > Can you perhaps provide a bit more information so that someone might > attempt to help you. > Lets start with the basics. Stuff like version and edition of Oracle. > Number of records. Size of the CLOBs. You know ... useful stuff. > Daniel Morgan We are using Oracle 8.1.7. The CLOBs are potentially very large although I don't know how large yet.
Mon, 21 Feb 2005 20:43:36 GMT

Page 1 of 1

[ 4 post ]