Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: numbering
Christophe <chocman_at_libertysurf.fr> wrote in message news:<MPG.1af97fc94ce4ecfc989691_at_news.oleane.fr>...
> Hello...
>
> I'd like to know if there's a way to obtain the middle-range weight of
> a row ?
>
> Thx in advance
> Chris
Chris, could you explain by what you mean by "middle-range weight" or a row?
If the table has been analyzed then various statistics about the table including average row length and number of rows is available in dba_tables (also all_tables) and column information is available via all_tab_columns.