Formula for Rowsize?

Hi,

I have a table called Category:

TAG                                      VARCHAR2(80)
DTYPE                                    CHAR(1)
TAGID                           NOT NULL NUMBER(38)
REPORT                                   NUMBER(38)

After I do an ANALYZE TABLE CATEGORY COMPUTE STATISTICS I:

select table_name,avg_row_len from sys.dba_tables

TABLE_NAME                     AVG_ROW_LEN
------------------------------ -----------
CATEGORY                                31

But when I

SELECT 	AVG((NVL(VSIZE(TAG),0)+1)+(NVL(VSIZE(DTYPE),0)+1)
	+(NVL(VSIZE(TAGID),0)+1)+(NVL(VSIZE(REPORT),0)+1)) 

Do I need to add 1 for each column which would equal 32?

I would rather error on the high side.

Thanks,

Park Received on Thu Feb 29 1996 - 00:00:00 CET