Re: Export data from oracle in fixed length ascii using toad
Date: Sat, 02 Jul 2005 00:49:42 +0200
Message-ID: <31ibc1168jj353f36sdu90hdoqekngpvkr_at_4ax.com>
On Thu, 30 Jun 2005 17:34:57 GMT, "Anandraj via DBMonster.com" <forum_at_DBMonster.com> wrote:
>Hi,
>I need to export data from oracle tables in fixed length ascii format. I can
>always put in a query to concatenate the columns values in fixed length & use
>spool to get the data. But I need to do this for quite some tables & each
>table's got a lot of columns. So i dont want to write queries.
>Do I have an option using toad (let me know the version also) or do i need to
>write a pl/sql taking the table names as input & getting all the columns from
>the system tables to do the same.
Go to http://asktom.oracle.com and search for 'sql unloader'. You''ll find a pl/sql utility taking the table name as a parameter, dumping every record in csv format. You can easily modify that.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Jul 02 2005 - 00:49:42 CEST