As far as I know up to Oracle 8.1.5 there's no way for that. I just remember that in Access 2.0 I did that and it's an offense with Oracle (my view point)
Good luck
- Ashish Shah <ar_shah_at_yahoo.com>
> wrote:
>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).
Be someone_at_0racledba.com - get your free mail from Oriole Corporation
http://www.oriolecorp.com - Performance tools for Oracle DBAs
Get email for your site ---> http://www.everyone.net
Received on Tue Oct 03 2000 - 00:46:18 CDT
