Re: Reading CLOBs

Valentin Minzatu wrote:
> >From a bird's eye view point, you could read, parse and write using
> PL/SQL. You could optimize the processing using arrays if the table is
> big for performance reasons as well.
>
> I am not very sure what makes the task different than anything else you
> could do in PL/SQL.
>
> Am I missing the question?

Suppose my data looks like this:

1111|Smith|John|H|19750101
1112|Jones|Anna||19690810

My understanding is that with DBMS_LOB I can read chunks specified in bytes or in characters. How do I detect where the line ends and the new line begins? Received on Fri Oct 27 2006 - 09:50:33 CDT