Re: Extracting the size of an Oracle LONG data type

select vsize(<expression>)
from table
should do it

Hth,

Sybrand Bakker, Oracle DBA

Kelvin Baggs wrote:

> Hi all
>
> I am wanting to query an Oracle database to find the size of an Oracle
> LONG, so that I can allocate the required amount of memory in a C program.
>
> Is it possible to find the size of a LONG in my table?
>
> Thanks in advance.
> Kelvin Baggs

--