Insert into returning into clob : CLOB « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE myClob
  2  (id NUMBER PRIMARY KEY,
  3   clob_data CLOB);

Table created.

SQL>
SQL>
SQL> DECLARE
  2    clobValue CLOB;
  3  BEGIN
  4    INSERT INTO myClob VALUES (104,EMPTY_CLOB())
  5    RETURNING clob_data INTO clobValue;
  6
  7  END;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL> drop table myClob;

Table dropped.

SQL>
SQL>








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