A function that parses a string

[Vladan Radovanovic]

Hello everyone, this question maybe more appropriate in Oracle forum but I guess more people visit this forum so I will get more exposure here. I need a pl/sql function that will parse an input string separated by a certain character and returns tokens one by one.
Is anyone aware where can I find this on the web or I should sit down and write it myself?
Thanks,
Vladan

[Mark Spritzler]

I don't knwo how to explain it right, so I will just tell you what to search for. And you can only do this in Oracle 9i
They have a new feature called external tables. This allows text files to act as an Oracle Table. The external table code looks very much like an SQL Loader control file.
search for external tables here.
Mark

[Ali Hassaan]

use following function when u know the index from where u have to find substring.
substr(vcustomer_fname,initial_index,final_index)