I have a column 'Test_desc' of CLOB datatype.
The data in the 'Test_desc' is of html format.
for example:
<table cellpadding="0" cellspacing="0"hspace="0" border="0"><tr><td valign="top"><b>
Goal:</b> </td><td>Verify this variable can control the rate for the console
</td></tr></table>
<b>
Test Procedure:</b>
<ol>
<li>Bring up the boot loader command-line interface
<li>Use set command to verify the default value is 9600
<li>Use set BAUD command to change the value
<li>Use set command to verify the change
<li>Verify the rate by running XMODEM
<li>For LOTR, repeat the above steps on slave switches
</ol>
I want to seperate the data starting with 'Test Procedure' and store it in another column. What would be the best way to split the CLOB data. The code should be able to split any size of data.(as the CLOB datatype can hold upto 4gb of data).
Thank you and regards,