OraFAQ Forum: SQL & PL/SQL » How to convert column to rows

Home » SQL & PL/SQL » SQL & PL/SQL » How to convert column to rows (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to convert column to rows [message #667113]

Fri, 08 December 2017 01:44

sss111ind
Messages: 636
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

Report message to a moderator

Re: How to convert column to rows [message #667114 is a reply to message #667113]

Fri, 08 December 2017 01:49

sss111ind
Messages: 636
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

Report message to a moderator

Previous Topic:	Help in Query for Required output
Next Topic:	sequence problem?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 09 10:35:52 CDT 2026