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: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 13 Mar 2003 09:49:28 -0800
Message-ID: <F001.0056944C.20030313094928@fatcity.com>


I think those solutions should be acceptable. Not sure if they are displaying any more information from the table. I was just given the test table to get the SQL script working....

Thanks a lot.

-----Original Message-----
Sent: Thursday, March 13, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L

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).
Received on Thu Mar 13 2003 - 11:49:28 CST

Original text of this message

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