Message-Id: <10479.104199@fatcity.com> From: Chuck Hamilton Date: Wed, 26 Apr 2000 08:58:16 -0700 (PDT) Subject: RE: multiple query --0-294702567-956764696=:17443 Content-Type: text/plain; charset=us-ascii Why can't you just to a 10-way join? I know it's a lot of table, but it can be done. Be prepared to spend some time tuning the query though. With that many tables the optimizer may not pick the best execution plan. Rahul wrote: oracle created PL/SQL for these situations... > ---------- > From: awaisb@paktel.com[SMTP:awaisb@paktel.com] > Reply To: ORACLE-L@fatcity.com > Sent: 26 April 2000 18:58 > To: Multiple recipients of list ORACLE-L > Subject: multiple query > > Hi, > I have more then 10 tables and are related by forign key combinations. I > need a single query which dynamicaly fetch records from all tables, first > see presence and then select only those tables which have those records. > > by > -- > Author: > INET: awaisb@paktel.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@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). > -- Author: Rahul INET: rahul@ratelindo.co.id 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@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). --------------------------------- Do You Yahoo!? Send online invitations with Yahoo! Invites. --0-294702567-956764696=:17443 Content-Type: text/html; charset=us-ascii

Why can't you just to a 10-way join? I know it's a lot of table, but it can be done. Be prepared to spend some time tuning the query though. With that many tables the optimizer may not pick the best execution plan.

Rahul <rahul@ratelindo.co.id> wrote:

oracle created PL/SQL for these situations...

> ----------
> From: awaisb@paktel.com[SMTP:awaisb@paktel.com]
> Reply To: ORACLE-L@fatcity.com
> Sent: 26 April 2000 18:58
> To: Multiple recipients of list ORACLE-L
> Subject: multiple query
>
> Hi,
> I have more then 10 tables and are related by forign key combinations. I
> need a single query which dynamicaly fetch records from all tables, first
> see presence and then select only those tables which have those records.
>
> by
> --
> Author:
> INET: awaisb@paktel.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> T! o REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru@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).
>
--
Author: Rahul
INET: rahul@ratelindo.co.id

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@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).


Do You Yahoo!?
Send online invitations with Yahoo! Invites.