Clob type column and clob type variable : CLOB « PL SQL Data Types « Oracle PL/SQL Tutorial

SQL>
SQL> CREATE TABLE test_clob(
  2      clob_id    NUMBER,
  3      clob_object CLOB
  4  );

Table created.

SQL>
SQL> DECLARE
  2        lv_clob_pointer_txt CLOB;
  3  BEGIN
  4        INSERT INTO test_clob (clob_id, clob_object)VALUES (1, '1234567890')
  5        RETURNING clob_object INTO lv_clob_pointer_txt;
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL> drop table test_clob;

Table dropped.

21.42.CLOB
	21.42.1.	Clob type column and clob type variable
	21.42.2.	Insert into returning into clob
	21.42.3.	Save data to clob type column
	21.42.4.	Writes into a CLOB
	21.42.5.	Demonstrations of SQL functions being applied to CLOB values
	21.42.6.	Retrieve the LOB locator created by the previous INSERT statement