Home » SQL & PL/SQL » SQL & PL/SQL » transpose
transpose [message #249437] Wed, 04 July 2007 08:32 Go to next message
Messages: 356
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)


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


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: 65137
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
Previous Topic: Checking duplicate ROWS
Next Topic: Help in Preparing the query
Goto Forum:

Current Time: Thu Aug 17 14:22:21 CDT 2017

Total time taken to generate the page: 0.12404 seconds