Re: Export tab delmited files.
Date: Thu, 28 Jan 1999 15:01:52 -0800
Message-ID: <eXjO0IxS#GA.223_at_nih2naaf.prod2.compuserve.com>
Check Out: utl_file_dir pfile parameter.
You should be able to create a PL/SQL proceedure that
can dump a flat file to your OS in any format you desire.
Remember that you'll have to define your format in the Proceedure.
You could also use a quick Pro*C or OCI application and do the same type of
thing.
Good Luck,
-GS
Robert Alexander wrote in message ...
>I don't use oracle but need to get data from an oracle system to load into
>our systems.
>
>The people running the oracle system say it is not possible to get a flat
>file of an oracle table delimited.
>
>They can give me fixed length but then they don't have enough space on
their
>systems since many fields are varchar(255).
>
>Is it possible to export an oracle table tab delimited? If it is could you
>give me the syntax?
>
>Thanks for your help.
>
>
>Robert Alexander
>robertalexander_at_cca-audit.com
>
>
Received on Fri Jan 29 1999 - 00:01:52 CET