RE: Query Help

From: Richard Ji <richard_at_letsplay.com>
Date: Mon, 2 Oct 2000 16:20:47 -0400
Message-Id: <10637.118341@fatcity.com>

You can't do it in SQL alone as far as I know (so if you did manage to do it in SQL, please let me know. :) ). I want to solve the same problem like you did. You have to use PL/SQL or other procedural language to process it and produce the result in the way you wanted.

Richard Ji

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ashish Shah Sent: Monday, October 02, 2000 3:36 PM
To: Multiple recipients of list ORACLE-L Subject: Query Help

Hi All,

I have a table called
user_prop
(user_id ,prop_id,prop_value)

When I do select user_id,prop_value from user_prop where prop_id in ('BDATE','SEX','CITY');

It would display like..

1234 18051999
1234 Male
1234 Toronto

Is there a way to display result like..

1234 18051999 Male Toronto --in one row..!!

Thanks.
Is there a way to display query results

---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ashish Shah
  INET: ar_shah_at_yahoo.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).

Received on Mon Oct 02 2000 - 15:20:47 CDT