Home » SQL & PL/SQL » SQL & PL/SQL » one column value ---> multiple rows
one column value ---> multiple rows [message #37859] Mon, 04 March 2002 04:46 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi,

I need a help on breaking column values and putting them into seperate rows.

My problem is I will get a column value(1,2,3,...etc)
and second column(a,b,c,d,...etc) n' number of values with ',' as delimeter.

I need to put (1,a) in one row, and (2,b) in second row etc.. for n' number of values. Does any body experienced with such things.

Pl provide me with an example.

Thank a lot
Ravi

Report message to a moderator

Re: one column value ---> multiple rows [message #37860 is a reply to message #37859] Mon, 04 March 2002 05:17 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
why do not u write pl/sql code for that.

Report message to a moderator

Re: one column value ---> multiple rows [message #37865 is a reply to message #37859] Mon, 04 March 2002 06:26 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi Pratap,

Can you tell me is there a way to do this in sql ?

Thanks for your help
Ravi

Report message to a moderator

Previous Topic: Executing a Script from within a Procedure
Next Topic: Duplicates in sql query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 04:35:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.