SQL Language (MOSC)

MOSC Banner

How to find a biggest document size stored as blob in oracle table?

I am able to get the overall size of the Blob by using below query

SELECT SUM(DBMS_LOB.GetLength("col_name"))/1024/1024 AS SizeMB FROM table_name;

However, I need to find the size of the biggest document stored in the blob.


Note : We are using 19.18 Oracle Enterprise edition standalone database.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center