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

Home -> Community -> Usenet -> c.d.o.server -> Re: can I do this in SQL??

Re: can I do this in SQL??

From: Cliff Buetikofer <clifford_buetikofer_at_merck.com>
Date: Fri, 22 Oct 1999 09:14:31 -0400
Message-ID: <38106337.63DC152@merck.com>


Look into PL/SQL. Using 2 loops with some column concatenation is very doable.

Cliff

Jorge wrote:
>
> Hi everyone, I'm trying to do this select ....
> I have two tables (user_indexes and user_ind_columns) and I want this
> output:
>
> index1 column1 column2 column3
> by row
>
> thanks

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.
Received on Fri Oct 22 1999 - 08:14:31 CDT

Original text of this message

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