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

Home -> Community -> Usenet -> c.d.o.tools -> Re: A Question about a query on three tables

Re: A Question about a query on three tables

From: Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de>
Date: 2000/05/22
Message-ID: <3928F10C.6E0DD3F4@bitoek.uni-bayreuth.de>#1/1

Markus Schwabe wrote:

I see no easy way to do this with a single query! But you could create a function
getkomm which concatenates the relevant data, and then code

select P_ID,NAME,getkomm(P_ID) from PARTNER where P_ID = 4711;

hth
Helmut Received on Mon May 22 2000 - 00:00:00 CDT

Original text of this message

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