Use dbms_lob.erase to remove value from clob type value
SQL>
SQL>
SQL> declare
2 l_c clob := 'Hello World!';
3 l_a number := 9;
4 begin
5 dbms_lob.erase( l_c, l_a, 6 );
6 dbms_output.put_line( 'The clob now = *' || l_c || '*' );
7 dbms_output.put_line( 'The amount that was erased was: ' || l_a );
8 end;
9 /
The clob now = *Hello *
The amount that was erased was: 7
PL/SQL procedure successfully completed.
SQL> --
Related examples in the same category