Home » SQL & PL/SQL » SQL & PL/SQL » How to convert column to rows (Oracle 11g)
How to convert column to rows [message #667113] Fri, 08 December 2017 01:44 Go to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi All,

I have to convert columns to rows but it seems not possible, please help me.


  create table testt(id number,deptno varchar2(100)) ;
      insert into testt values(1,'20,30,40');
      insert into testt values(2,'50,30,40');
      insert into testt values(2,'90,20,40,10');
      commit;
      select * from testt;

I want to see as 10 rows with id and with corresponding deptno.How can I do that.

Regards,
Nathan
Re: How to convert column to rows [message #667114 is a reply to message #667113] Fri, 08 December 2017 01:49 Go to previous message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi All,

Sorry guys, I have found the exact link what Michel Sir given, please ignore it.

Anyway thank you very much.

http://www.orafaq.com/forum/mv/msg/95011/569066/#msg_569066

Regards,
Nathan
Previous Topic: Help in Query for Required output
Next Topic: sequence problem?
Goto Forum:
  


Current Time: Thu Mar 28 16:44:08 CDT 2024