storage size of a long datatype

From: Glenn Stauffer <stauffer_at_cc.swarthmore.edu>
Date: Wed, 16 Nov 1994 16:24:27 -0500
Message-ID: <stauffer-1611941624270001_at_stauffer.swarthmore.edu>

I am running a script to estimate average row length on several Oracle data tables. The script to calculate the size of a column looks like this:

nvl(vsize(column_name),0)+1

This calculation fails when applied against a column defined to be datatype long.

How would I calculate the byte size of a long data column?

Thanks.

Glenn Stauffer
Swarthmore College DBA Received on Wed Nov 16 1994 - 22:24:27 CET

This message: [ Message body ]
Next message: kevins_at_bmd.com: "DDE from forms?"
Previous message: WILLIAM AIKMAN : "HELP: Forms 4.0 memory problem"
Next in thread: Lawrence James: "Re: storage size of a long datatype"
Reply: Brian W. Gardner: "Re: storage size of a long datatype"
Reply: Lawrence James: "Re: storage size of a long datatype"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message