Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query Help
I don't understand your description of the problem.
What is it that connects a column with a descriptiveName? Maybe if you gave an example of some data it would help. Mike
"Robert Nurse" <rnurse_at_cudbytech.net> wrote in message
news:a967f5b9.0407290934.433fc1b8_at_posting.google.com...
> Hi All,
>
> I've got a report to do and I need a little help with the query.
> Here's the table structure
>
> rowID PK
> descriptiveName
> Col2 FK
> Col3
> Col4
> Col5
> Col6
>
> Col3 through Col6 contain values taken from rowID. Just as a side
> note, this table is not normalized. Correct? Anyway, when I query
> the table instead of displaying the data in Col3 through Col6, I'd
> like to display the corresponding descriptiveName for those values.
> Could someone give me a hint at a PL/SQL solution for this? I'm new
> to PL/SQL.
Received on Thu Jul 29 2004 - 21:23:31 CDT