Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 16th, 2010, 10:44 AM
Registered User
 
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transpose of data in a table...

hi friends,

create table goods(ITEM_NO number,
PRODUCT_NAME varchar2(20),
COMPANY_NAME varchar2(20));

insert into goods values(1,'TV','SONY');
insert into goods values(2,'COMPUTER','HP');

--------------------============--------------------
Generally when we select the data from a table the o/p format will be...

ITEM_NO PRODUCT_NAME COMPANY_NAME
1 TV SONY
2 COMPUTER HP

But, I want to print the the table in the below format...

ITEM_NO 1 2
PRODUCT_NAME TV COMPUTER
COMPANY_NAME SONY HP

Using oracle SQL or PL/SQL
Please, help me.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose Rows/Pivot Table prasanta2expert Access 0 April 26th, 2008 01:01 AM
Transpose the data yogeshyl Excel VBA 2 September 15th, 2007 11:09 AM
Transpose Table - Editing the MS KB code gwolfe Access 2 September 14th, 2007 02:48 AM
How to Transpose this type data jaincafe Access 1 November 27th, 2006 05:58 AM
Help with transpose fegasa Excel VBA 3 April 7th, 2006 03:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.