Use dbms_lob.getchunksize to get the clob column size : dbms_lob « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_lob

Use dbms_lob.getchunksize to get the clob column size

  
SQL>
SQL>
SQL> create table my_lob(
  2        id number,
  3        c clob )
  4      /

Table created.

SQL> insert into my_lob values ( 1, empty_clob() );

1 row created.

SQL>
SQL>
SQL> select dbms_lob.getchunksize( c ) from my_lob;
DBMS_LOB.GETCHUNKSIZE(C)
------------------------
                    8132

1 row selected.

SQL>
SQL> drop table my_lob;

Table dropped.

SQL> --








Related examples in the same category

1.Call dbms_lob.write to write value to clob type value
2.Use dbms_lob.writeappend to append value to clob type value
3.Use dbms_lob.compare to compare
4.Use dbms_lob.compare to compare clob type value with offset
5.Use dbms_lob for load clob data from file
6.This block demonstrates the use of DBMS_LOB.COPY.
7.This block demonstrates DBMS_LOB.GETLENGTH.
8.DBMS_LOB.SUBSTR: Select the first 50 characters of clob_col, and the first 25 bytes of blob_col, for each row.
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