Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!x38g2000yqb.googlegroups.com!not-for-mail From: ddf Newsgroups: comp.databases.oracle.misc Subject: Re: Column into Row Date: Thu, 3 Sep 2009 06:11:37 -0700 (PDT) Organization: http://groups.google.com Lines: 31 Message-ID: <84b9a0f7-585b-4b38-b0cc-e46b2425f17a@x38g2000yqb.googlegroups.com> References: NNTP-Posting-Host: 138.32.80.20 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1251983497 13726 127.0.0.1 (3 Sep 2009 13:11:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 3 Sep 2009 13:11:37 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: x38g2000yqb.googlegroups.com; posting-host=138.32.80.20; posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; Embedded Web Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Sep 3, 6:45=A0am, keeri wrote: > Hi all, > > I have a table like this .. > > Name =A0 =A0 ID > -------- =A0 =A0 ---- > A =A0 =A0 =A0 =A0 =A0 =A01 > B =A0 =A0 =A0 =A0 =A0 =A02 > C =A0 =A0 =A0 =A0 =A0 =A03 > D =A0 =A0 =A0 =A0 =A0 =A04 > E =A0 =A0 =A0 =A0 =A0 =A05 > > If table is queried , I need like .. > > Name =A0 =A0 A =A0 =A0 B =A0 =A0 =A0C .. > ID =A0 =A0 =A0 =A0 =A0 1 =A0 =A0 2 =A0 =A0 =A0 3 .. > > Can anyone help me on this issue ? > > Thanx, > Keerthi c Knowing the version of Oracle you're using helps tremendously as the options for providing that output vary with the age of the release. Post your version to 4 or 5 numbers so someone can help you without guessing. David Fitzjarrell