Re: numbering

"Christophe" <chocman_at_libertysurf.fr> schrieb im Newsbeitrag news:MPG.1afad1e6663d8d3c989692_at_news.oleane.fr...
> In article <2687bb95.0404281553.7b063d1_at_posting.google.com>,
> Mark.Powell_at_eds.com says...
> > d then various statistics about the table
> > including average row length and number of ro
> >
>
> Sorry I wasn't clear enough in my question but I think you understand the
> principal ;-)
>
> It deals with average row length. But no analyze have been done, and I
> can't do it myself. More of all, my DBA don'twant to hear about that
> "old" Oracle 7.3...
> Is there a 'manual' way of calculating a 'theorical' length ?
>
> Thanx for your help
> Chris

Try PL/SQL built-in funktion VSIZE ( ), for all columns needed, it will give You the real size of the column with repect to its datatype:

SQL> select vsize('IAMATEXT') bytes from dual;

     BYTES

         8

1 Zeile wurde ausgewählt.

SQL> select vsize(12345678) bytes from dual;

     BYTES

         5

1 Zeile wurde ausgewählt.

SQL> select vsize(sysdate) bytes from dual;

     BYTES

         8

1 Zeile wurde ausgewählt.

SQL> You may use it somthing like AVG ( VSIZE ( ... ) ) to get the average of the table ... theoretical values may not be helpful in Your case.

hth, Jan Received on Thu Apr 29 2004 - 06:13:59 CDT