beginner - unload tables with fix length?

From: Christof Müller <christof.mueller_at_andaro.com>
Date: Fri, 09 Feb 2001 01:56:57 +0000
Message-ID: <3A834E69.47DA4CAE@andaro.com>

Here my example:
create emp (id number(12), name varchar2(30))

I would like to extract the table and the only way I currently know is: spool xxx
Select id||';'||name||';' from emp;
spool off

The result is:
miller;1
smith;2

But I wouldn't like to have ';' separated fields but fix length (length of
column definitions:

miller                       1
smith                       2

Can anybody tell me how to deal with the problem????? Received on Thu Feb 08 2001 - 19:56:57 CST