I have some question about CLOB type in Oracle 10g.
I have some CLOB field MY_CLOB CLOB which is binary data:
Each chunk is double that my application "serialize" some array of doubles
to binary data and then flushes all this stuff to CLOB.
The number of "chunks" is about 1000+.
How it possible to read some double from chunk #n by utilizing only
Oracle Server infrastructure? Is there some way at all to do it? Please advice.
Whether it's a good solution from design/performance/usability points of view
to make some frequent mathematical operations on these chunks that are placed inside CLOB and then updating this CLOB by using only Oracle Server infrastructure? Usually we are using DB to store data. And data manipulation is more Application-side stuff. Please advice.