Home » SQL & PL/SQL » SQL & PL/SQL » Parsing strings from variable amount of elements
Parsing strings from variable amount of elements [message #186966] Thu, 10 August 2006 06:07 Go to next message
meika_lainen
Messages: 1
Registered: August 2006
Location: Finland
Junior Member
Hello,

I'm quite green in PL/SQL so please have patience with me. I have a following problem: I have some rows in database which can have 1 - x elements, like this:

select myrow from mytable;

prints out something like this:

1
2 4 5 6
3 4
55 55 665
333 333 333

etc.

And I am trying to create a select clause which chops them individually row by row, like this:

1
2
4
5
6
3
4
55
55
665

etc.

I tried to use SUBSTR & INSTR combinations, but couldn't figure out dynamic script for this. If there was a fixed amount of elements, this would have been easy. Any help is highly appreciated, thanks in advance.

-Meika




Re: Parsing strings from variable amount of elements [message #186974 is a reply to message #186966] Thu, 10 August 2006 06:51 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Look here.

MHE
Previous Topic: SQL equivalence
Next Topic: Invalid month error...
Goto Forum:
  


Current Time: Wed Dec 07 20:50:11 CST 2016

Total time taken to generate the page: 0.08379 seconds