Call dbms_lob.write to write value to clob type value

  
  2
SQL>      declare
  2        l_clob clob := '12345';
  3      begin
  4        dbms_lob.write( l_clob, 2, 3, 'AB' );
  5        dbms_output.put_line( l_clob );
  6        dbms_lob.write( l_clob, 2, 9, 'CD' );
  7        dbms_output.put_line( l_clob );
  8      end;
  9      /
12AB5
12AB5   CD

PL/SQL procedure successfully completed.

SQL>
SQL> --

Related examples in the same category

1.	Use dbms_lob.getchunksize to get the clob column size
2.	Use dbms_lob.writeappend to append value to clob type value
3.	Use dbms_lob.compare to compare
4.	Use dbms_lob.compare to compare clob type value with offset
5.	Use dbms_lob for load clob data from file
6.	This block demonstrates the use of DBMS_LOB.COPY.
7.	This block demonstrates DBMS_LOB.GETLENGTH.
8.	DBMS_LOB.SUBSTR: Select the first 50 characters of clob_col, and the first 25 bytes of blob_col, for each row.
9.	Use DBMS_LOB.GETLENGTH to get the length of a clob type variable
10.	DBMS_LOB.CREATETEMPORARY
11.	DBMS_LOB.ERASE
12.	DBMS_LOB.FREETEMPORARY
13.	DBMS_LOB.ISTEMPORARY
14.	DBMS_LOB.READ
15.	DBMS_LOB.WRITE
16.	This script tests the DBMS_LOB.LOADFROMFILE procedure

Call dbms_lob.write to write value to clob type value : dbms_lob « System Packages « Oracle PL / SQL

Related examples in the same category