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

Home -> Community -> Usenet -> c.d.o.misc -> Can we make a single line to return all the values

Can we make a single line to return all the values

From: Rangeshwara Reddy Kona <konareddy_at_hotmail.com>
Date: Fri, 9 Nov 2001 18:52:15 -0800
Message-ID: <3bec9657$1@news.cadence.com>


Hi All,

I have a lookup table which says
User_tab
123

User_ID Look_Id Set_property

123     1     yes
123    2     no
123    3.     yes

Can I return a single row line
123, 1, yes, 2, no, 3, yes

Thanks in Advance Received on Fri Nov 09 2001 - 20:52:15 CST

Original text of this message

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