Database Administration (MOSC)

MOSC Banner

How to check the exact size of a picture file in a LONG RAW column of a table.

My HR System needs to insert a photo of each one of my employees in my table PESSOA_FISICA_FOTO in the LONG RAW column, the IM_PESSOA_FISICA:

Table TASY.PESSOA_FISICA_FOTO:

Name Null? Type

-------------------------- -------- ------------

CD_PESSOA_FISICA NOT NULL VARCHAR2(10)

IM_PESSOA_FISICA NOT NULL LONG RAW

...

This mentioned photo is a '.png' file, which its size can vary depends upon the size of the file, and store more or less disk space in my IM_PESSOA_FISICA table column.

I need to check the allocated disk space of each photo in each one of the rows in my table PESSOA_FISICA_FOTO, so I can have the exactly disk space allocated in my table,

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