I have a column 'Test_desc' of CLOB datatype.
The data in the 'Test_desc' is of html format.
<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
<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
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).
It depends on the Oracle version, there were a number where the various SQL functions like SUBSTR and INSTR weren't overloaded to accommodate LOBs. There are also a number of cases where the order of parameters to the SQL version and DBMS_LOB version of the functions are different, which is a really fun way to introduce bugs...