Re: determine length of whole row
From: Martin Doering <doeringm_at_gmx.de>
Date: Wed, 22 Aug 2001 12:46:41 GMT
Message-ID: <3b83a971.113971462_at_news.mn.man.de>
Date: Wed, 22 Aug 2001 12:46:41 GMT
Message-ID: <3b83a971.113971462_at_news.mn.man.de>
On Tue, 21 Aug 2001 18:47:59 +0100, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>You could make some calculations from precision and scale from
>user_tab_columns
This is, what I found out to get the length of the whole row:
select sum(DATA_LENGTH)
from user_tab_columns
where TABLE_NAME = 'TABLE';
Thanx
-- MartinReceived on Wed Aug 22 2001 - 14:46:41 CEST