Re: How to unload data
From: paul sun <jsun_at_staffordbc.gov.uk>
Date: 15 Sep 2003 07:01:19 -0700
Message-ID: <78223844.0309150601.6afd2e89_at_posting.google.com>
Date: 15 Sep 2003 07:01:19 -0700
Message-ID: <78223844.0309150601.6afd2e89_at_posting.google.com>
[Quoted] if you have MS Access, it will be quite simple. go to access---- select open, select ODBC as source, put the table(s) you want to export into the access.---choose export option from access---then simply following the wizard to finish the rest.
good luck!
"Julia Sats" <julia.sats_at_sympatico.ca> wrote in message news:<Pqw5b.8890$Kj.919894_at_news20.bellglobal.com>...
> Hi,
>
> Oracle contains SQL*Loader for loading data to Oracle.
> Does exis any tool for quickly unload (extract data) from Oracle's table to
> TXT file, preferable to comma separete format.
>
> I can use for it UTL_FILE but I need to work with every record of the table.
>
> Thanks
Received on Mon Sep 15 2003 - 16:01:19 CEST