DBMS_LOB.SUBSTR: Select the first 50 characters of clob_col, and the first 25 bytes of blob_col, for each row.

  
SQL>
SQL>
SQL> CREATE TABLE lobdemo (
  2    key NUMBER,
  3    clob_col CLOB,
  4    blob_col BLOB);

Table created.

SQL>
SQL>
SQL> column CLOB_Data format a60
SQL> column BLOB_Data format a60
SQL> SELECT key,
  2         DBMS_LOB.SUBSTR(clob_col, 50) CLOB_Data,
  3         DBMS_LOB.SUBSTR(blob_col, 25) BLOB_Data
  4    FROM lobdemo
  5    WHERE key IN (0, 100, 101, 102, 103, 1000, 1001, 1002)
  6    ORDER BY key;

no rows selected

SQL>
SQL> drop table lobdemo;

Table dropped.

SQL>

Related examples in the same category

1.	Use dbms_lob.getchunksize to get the clob column size
2.	Call dbms_lob.write to write value to clob type value
3.	Use dbms_lob.writeappend to append value to clob type value
4.	Use dbms_lob.compare to compare
5.	Use dbms_lob.compare to compare clob type value with offset
6.	Use dbms_lob for load clob data from file
7.	This block demonstrates the use of DBMS_LOB.COPY.
8.	This block demonstrates DBMS_LOB.GETLENGTH.
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

DBMS_LOB.SUBSTR: Select the first 50 characters of clob_col, and the first 25 bytes of blob_col, for each row. : dbms_lob « System Packages « Oracle PL / SQL

Related examples in the same category