Home » SQL & PL/SQL » SQL & PL/SQL » transpose
transpose [message #249437] Wed, 04 July 2007 08:32 Go to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Hi.. I have a table with 82 fields.


codeno number(3),
cardn number(5),
a1 varchar2(1),
a2 varchar2(1),
.
.
.
.
a60 varchar2(1),
b1 varchar2(1),
b2 varchar2(1),
.
.
.
.
b20 varchar2(1)





sample data:

codeno  cardn   a1	a2	a3
73	7777	a	b	c







I am in need of inserting this data int a a table having three fields.


cardno number(5),
q_no varchar2(2),
answer varchar2(1)


like

cardno	q_no	answer
7777     a1     a
7777     a2     b
7777     a3     c


etc



please help I need it very urgently..
thank you all
Re: transpose [message #249440 is a reply to message #249437] Wed, 04 July 2007 08:42 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Nothing is urgent in forum
2/ This kind of question is answered almost once per DAY
3/ Search function is there
4/ Search for "pivot"
This one is closed
./fa/448/0/
Regards
Michel
Previous Topic: Checking duplicate ROWS
Next Topic: Help in Preparing the query
Goto Forum:
  


Current Time: Mon Dec 05 09:10:04 CST 2016

Total time taken to generate the page: 0.10559 seconds