Re: storage size of a long datatype

Glenn Stauffer (stauffer_at_cc.swarthmore.edu) wrote:
: 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
: How would I calculate the byte size of a long data column?

There may be more than one way, but I wrote a C program that selects the data into a buffer, and searches for the end. I can give you more info (and some code) if you are interested.

--
Brian W. Gardner                       "Captain, I protest; I am not a
495 Park Blvd.                          merry man!" - Lt. Worf
Worthington, OH 43085
bgardner_at_infinet.com (home)            gardner_at_ems.abb.com (office)