Wednesday, July 24, 2024

How to get max LOB size in column - DB2 database

 


SELECT MAX(LENGTHB(LOB_COLUMN)) FROM TABLE;

No comments:

Post a Comment

what is catcon.pl (Catalog Container Script) and why very useful for Oracle Multitenant Database ?

  catcon.pl (Catalog Container Script) is an Oracle utility introduced with the Multitenant Architecture (CDB/PDB) to execute SQL scripts ...