RE: dump joined tables into Acess

How about creating a view and using Jared's sqlunloader to dump from the view ?
I do not think it matters if the data is in a table or a view.

Mary Ruiz/Atlanta GA

-----Original Message-----
From: John Dunn
Sent: Friday, October 13, 2000 5:01 AM
To: Multiple recipients of list ORACLE-L Subject: RE: dump joined tables into Acess

Dont have Access on site I'm afraid

John

> -----Original Message-----
> From: Jai B. Sanker [SMTP:jsanker_at_pl-x.com]
> Sent: 12 October 2000 19:41
> To: Multiple recipients of list ORACLE-L
> Subject: RE: dump joined tables into Acess
>
> How about creating a view and then pull the data through ODBC connection
> to
> access....
>
> Jai
> -----Original Message-----
> Sent: Thursday, October 12, 2000 9:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I need to join 2 tables and dump the output into a Access friendly format.
>
> I have looked at Jared's dump utility but this only does single tables.
>
> can I create a tempory table or something?
>
> Oracle version is 8.0.5 on AIX
>
> Can anyone help?
>
> John
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jai B. Sanker
> INET: jsanker_at_pl-x.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: john.dunn_at_sefas.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may