Oracle Database – how to get information with ChatGPT about the size of Oracle CLOB or BLOB columns can be obtained using the DBMS_LOB.GETLENGTH function the result is the length of a LOB (Large Object) value in bytes

SELECT DBMS_LOB.GETLENGTH(your_clob_column) AS clob_size
FROM your_table
WHERE your_condition;
SELECT DBMS_LOB.GETLENGTH(your_blob_column) AS blob_size
FROM your_table
WHERE your_condition;

This entry was posted on Mittwoch, Januar 17th, 2024 at 19:21 and is filed under Administration, ORACLE Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.