Update clob data : CLOB « Large Objects « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE myClobTable (id NUMBER,clob_data CLOB);

Table created.

SQL>
SQL> CREATE TABLE myLongTable (id NUMBER,long_data LONG);

Table created.

SQL>
SQL> INSERT INTO myLongTable VALUES (100,RPAD('A',200000,'A'));

1 row created.

SQL>
SQL>
SQL> update myClobTable set clob_data =(select to_lob(long_data)from
  2                  myLongTable where id =100)
  3
SQL> drop table myLongTable;

Table dropped.

SQL>
SQL>
SQL> drop table myClobTable;

Table dropped.








34.4.CLOB
34.4.1.Creating Tables Containing CLOB Objects
34.4.2.Initialize CLOB column
34.4.3.Read clob data to varchar2 type variable
34.4.4.Read clob type data, DBMS_LOB.READ
34.4.5.Adding Content to a CLOB
34.4.6.Loading data to the CLOB by using BFILE
34.4.7.Performing basic string operations on CLOBs
34.4.8.Reading and Writing to a CLOB
34.4.9.Obtain Clob data pointer
34.4.10.close Clob data pointer
34.4.11.Open the CLOB
34.4.12.Insert into clob column
34.4.13.Update clob data
34.4.14.Compare date value after to_char() and trim()
34.4.15.Convert string to clob
34.4.16.Copy clob data