Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 <rahul_at_ratelindo.co.id> wrote:
oracle created PL/SQL for these situations...
> ----------
> From: awaisb_at_paktel.com[SMTP:awaisb_at_paktel.com]
> Reply To: ORACLE-L_at_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_at_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_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).
>
-- Author: Rahul INET: rahul_at_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_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). --------------------------------- Do You Yahoo!? Send online invitations with Yahoo! Invites. --0-294702567-956764696=:17443 Content-Type: text/html; charset=us-ascii <P>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.</P> <P><B><I>Rahul <rahul_at_ratelindo.co.id></B></I> wrote:<BR></P> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">oracle created PL/SQL for these situations...<BR><BR>> ----------<BR>> From: <A href="mailto:awaisb_at_paktel.com">awaisb_at_paktel.com</A>[SMTP:awaisb_at_paktel.com]<BR>> Reply To: ORACLE-L_at_fatcity.com<BR>> Sent: 26 April 2000 18:58<BR>> To: Multiple recipients of list ORACLE-L<BR>> Subject: multiple query<BR>> <BR>> Hi,<BR>> I have more then 10 tables and are related by forign key combinations. I<BR>> need a single query which dynamicaly fetch records from all tables, first<BR>> see presence and then select only those tables which have those records.<BR>> <BR>> by<BR>> -- <BR>> Author: <BR>> INET: awaisb_at_paktel.com<BR>> <BR>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>> San Diego, California -- Public Internet access / Mailing Lists<BR>> --------------------------------------------------------------------<BR>> T! o REMOVE yourself from this mailing list, send an E-Mail message<BR>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>> the message BODY, include a line containing: UNSUB ORACLE-L<BR>> (or the name of mailing list you want to be removed from). You may<BR>> also send the HELP command for other information (like subscribing).<BR>> <BR>-- <BR>Author: Rahul<BR>INET: rahul_at_ratelindo.co.id<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE! ><p><br><hr size=1><b>Do You Yahoo!?</b><br> Send online invitations with Yahoo! Invites.Received on Wed Apr 26 2000 - 10:58:16 CDT
![]() |
![]() |