Convert rows to columns in a table.

Welcome Guest ( Log In | Register )

Convert rows to columns in a table.

Options

BujjigaduVZM View Member Profile	Apr 24 2012, 05:17 AM Post #1
Newbie Group: Members Posts: 2 Joined: 24-April 12 Member No.: 47,125	How do I convert rows in oracle table to columns by writing a query? Here is my table. EID QNo Qual YOP 101 1 B.Tech 2004 101 2 M.Tech 2006 102 1 B.Tech 2003 102 2 M.Tech 2005 102 3 MBA 2007 Now I want the above table in the following format...... EID Qual1 YOP1 Qual2 Yop2 Qual3 Yop3 101 B. Tech 2004 M.Tech 2006 102 B. Tech 2003 M.Tech 2005 MBA 2007 I have maximum of 8 Qualifications, please let me know how to achieve this in oracle. Thanks in advance.

burleson View Member Profile	Apr 24 2012, 01:11 PM Post #2
Advanced Member Group: Members Posts: 10,370 Joined: 26-January 04 Member No.: 13	See here: http://www.dba-oracle.com/t_converting_rows_columns.htm -------------------- Hope this helps. . . Donald K. Burleson Oracle Press author Author of Oracle Tuning: The Definitive Reference

BujjigaduVZM View Member Profile	Apr 24 2012, 11:03 PM Post #3
Newbie Group: Members Posts: 2 Joined: 24-April 12 Member No.: 47,125	QUOTE (burleson @ Apr 24 2012, 01:11 PM) See here: http://www.dba-oracle.com/t_converting_rows_columns.htm Hi, Thanks for the reply, it's good, but i wanted the result in different columns not in a single column.

burleson View Member Profile	Apr 25 2012, 12:35 PM Post #4
Advanced Member Group: Members Posts: 10,370 Joined: 26-January 04 Member No.: 13	Try this: http://www.dba-oracle.com/t_display_multip...s_same_rows.htm -------------------- Hope this helps. . . Donald K. Burleson Oracle Press author Author of Oracle Tuning: The Definitive Reference

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Time is now: 22nd May 2013 - 09:44 PM