Re: determine length of whole row
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 21 Aug 2001 18:47:59 +0100
Message-ID: <3B829ECF.5691_at_yahoo.com>
Date: Tue, 21 Aug 2001 18:47:59 +0100
Message-ID: <3B829ECF.5691_at_yahoo.com>
Martin Doering wrote:
>
> I would like to do an unload of data with fixed length by using
> SQLPLUS. For that I need to set the linesize to the right length for
> my table. But how can I know the size of a whole line - means all
> fields in addition? Any formula/statement?
>
> For small tables I can calculate this by hand. But we have tables with
> too soooo fileds...
>
> --
> Martin Doering
[Quoted] You could make some calculations from precision and scale from user_tab_columns
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Tue Aug 21 2001 - 19:47:59 CEST