Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating Flat Files from Oracle Tables
Toad, including the free version can do it, jsut do the query that selects the approprite rows, then right click on the data grid select save as, then save to a file as text or html table and pick the delimiter or give it you own choice, you can also double quote text include null and column headers
you can also for smaller resultset save to the clipboard and then pste directly into excel as tab delimited works great
In article <XX925.1389$7W2.12448_at_news1.wwck1.ri.home.com>, "Sally Madeira"
<sallym1_at_home.com> wrote:
>Hi,
>
>I am looking for a way to create an export that sends data to a file in
>either Ascii or Fixed
>Length. I do not want to have to use VB to do this (Of course if it is the
>only way then I will
>have to live with that). Does anyone have any tricks that I could use to do
>this whether through
>SQLPlus or someother oracle tools.
>
>Thanks in advance
>Sally
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT