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: how do I combine 24 rows(3 columns) into one row (

Re: how do I combine 24 rows(3 columns) into one row (

From: Nuno Souto <nsouto_at_acay.com.au>
Date: Sat, 20 Feb 1999 00:26:38 +1100
Message-ID: <36cd688c.0@job.acay.com.au>

Try PL/SQL. With SQL you need to join the table 24 times to itself....

HTH --
Cheers
Nuno Souto
nsouto_at_acay.com.au
http://www.acay.com.au/~nsouto/welcome.htm jennfier wrote in message <7X%y2.51694$O54.62998_at_newscene.newscene.com>...
>
>can somebody give the sql please!
Received on Fri Feb 19 1999 - 07:26:38 CST

This message: [ Message body ]
Next message: Nuno Souto: "Re: sqlnet through firewall!"
Previous message: Nuno Souto: "Re: Can't PL/SQL do the simple stuff that Transact-SQL can?"
In reply to: jennfier: "how do I combine 24 rows(3 columns) into one row ("
Next in thread: jennfier: "thanks here is solution"
Reply: jennfier: "thanks here is solution"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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