determine length of whole row
From: Martin Doering <doeringm_at_gmx.de>
Date: Tue, 21 Aug 2001 12:58:00 GMT
Message-ID: <3b825a16.28120204_at_news.mn.man.de>
[Quoted] 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?
Date: Tue, 21 Aug 2001 12:58:00 GMT
Message-ID: <3b825a16.28120204_at_news.mn.man.de>
[Quoted] 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 DoeringReceived on Tue Aug 21 2001 - 14:58:00 CEST