Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Corrected SQL Question...

Re: Corrected SQL Question...

From: <rgaffuri_at_cox.net>
Date: Thu, 13 Mar 2003 09:04:07 -0800
Message-ID: <F001.005692EF.20030313090407@fatcity.com>


I think its easier if you do it cross-tab

AUS DAL DAL AUS Is that acceptable?
Or just select

AUS DAL If it also has a DAL AUS

Are either of those metods acceptable? If so, pick one and Ill show you how to do it.
>
> From: "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> Date: 2003/03/13 Thu AM 11:19:15 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Corrected SQL Question...
>
> Okay, let me do this right this time,... (Now that I have my hot tea going;)
>
> Here is the test data:
>
> SQL> select c1,c2 from cp;
>
> C1 C2
> --- ---
> AUS DAL
> AUS HOU
> DAL AUS
> DAL HOU
> DAL LIT
> DAL XYZ
> HOU AUS
> HOU DAL
> HOU LIT
> HOU XYZ
> LIT DAL
>
> C1 C2
> --- ---
> LIT HOU
> XYZ DAL
> XYZ HOU
>
> 14 rows selected.
>
> SQL>
>
> Here is what is required:
>
> C1 C2
> --- ---
> AUS DAL
> DAL AUS
> AUS HOU
> HOU AUS
> DAL HOU
> HOU DAL
> DAL LIT
> LIT DAL
> DAL XYZ
> XYZ DAL
> HOU LIT
> LIT HOU
> HOU XYZ
> XYZ HOU
>
>
> I think I am clear now...
> Sorry about the wrong test data earlier...
>
>
> Thanks,
>
> - Kirti
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Mar 13 2003 - 11:04:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US