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: Transpose in SQL

Re: Transpose in SQL

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1998/10/23
Message-ID: <3630A33A.DD42FDFB@hk.super.net>#1/1

Not possible only with SQL. You may utilize PL/SQL as well.

Ng K C Paul wrote:

> Is it possible to do the Transpose function using SQL like under Excel's
> Paste Special - change columns of data to rows, and vice versa?

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer
Received on Fri Oct 23 1998 - 00:00:00 CDT

Original text of this message

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