Re: PL/SQL: parsing csv string and return it as rowset

"joes" <joes_at_bluewin.ch> wrote in message news:26760a3e.0402191351.7c13c9dd_at_posting.google.com...
| Hello there
|
| I have currently in a table csv concateneted strings. Now I got the
| beautiful task to build reports on it, but for this I have first to
| splitt those in their respetive tokens and build tables on it.
|
| So my first idea is to do this at the fly. Means building a view on
| this which uses a PL/SQL function for the parsing of the strings.
|
| Unfortunately I have to use Oracle 8.1.7. I have seen that Oracle 9
| supports "pipelined" returns of tables, but version 8 does this not.
|
| So I need a little bit more help to get this done. Could you bring me
| up with some good examples and suggestions how I could solve my
| challenge ?
|
| - How to return dynamical arrays from a pl sql funcion ?
| - How to splitt strings into its token with pl /sql ?
| - How to return a "virtual" rowset from pl /sql so that I can execute
| a "select ..." statement on it ?
| - Other suggestions how to achieve this ?
|
| thank you best regards
| Mark

see previous posts on: 'example: PIPELINED function' and 'Input array string'

;-{ mcs Received on Fri Feb 20 2004 - 10:15:39 CST