This block demonstrates DBMS_LOB.GETLENGTH. : dbms_lob « System Packages « Oracle PL / SQL






This block demonstrates DBMS_LOB.GETLENGTH.

  

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

Table created.

SQL>
SQL>
SQL> set serveroutput on format wrapped
SQL> DECLARE
  2    CURSOR c_LOBQuery IS
  3      SELECT key, clob_col, blob_col
  4      FROM lobdemo
  5      WHERE key IN (0, 100, 101, 102, 103, 1000, 1001, 1002)
  6      ORDER BY key;
  7  BEGIN
  8    FOR v_Rec IN c_LOBQuery LOOP
  9      DBMS_OUTPUT.PUT_LINE('Key: ' || v_Rec.key);
 10      DBMS_OUTPUT.PUT_LINE('  Length of CLOB: ' ||
 11        DBMS_LOB.GETLENGTH(v_Rec.clob_col));
 12      DBMS_OUTPUT.PUT_LINE('  Length of BLOB: ' ||
 13        DBMS_LOB.GETLENGTH(v_Rec.blob_col));
 14    END LOOP;
 15  END;
 16  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table lobdemo;

Table dropped.

SQL>
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.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