Use dbms_lob.substr to get part of clob data : DBMS_LOB « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_LOB
SQL>
SQL>
SQL> set echo on
SQL>
SQL>
SQL> create table t ( str varchar2(10), lob clob );

Table created.

SQL>
SQL> insert into t values ( 'hello', 'hello' );

1 row created.

SQL>
SQL> select substr( str, 3, 2 ), dbms_lob.substr( lob, 3, 2) lob
  2  from t
  3  /

SU
--
LOB
--------------------------------------------------------------------------------
ll
ell


SQL>
SQL> drop table t;

Table dropped.








31.12.DBMS_LOB
31.12.1.DBMS_LOB Package
31.12.2.Print clob data out
31.12.3.Use dbms_lob.getlength to get the length of a clob data
31.12.4.Show Java source file
31.12.5.Use dbms_lob package to deal with clob data
31.12.6.Use dbms_lob.getlength and dbms_lob.substr with blob type column
31.12.7.Use dbms_lob.substr to get part of clob data
31.12.8.DBMS_LOB.READ
31.12.9.Load a file