my dog learned polymorphism*
The moose likes JDBC and the fly likes A function that parses a string Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "A function that parses a string" Watch "A function that parses a string" New topic
Author

A function that parses a string

Vladan Radovanovic
Ranch Hand

Joined: Mar 20, 2000
Posts: 216
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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Ali Hassaan
Ranch Hand

Joined: May 16, 2001
Posts: 103
use following function when u know the index from where u have to find substring.
substr(vcustomer_fname,initial_index,final_index)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: A function that parses a string
 
Similar Threads
Protecting my JavaScript Code
Function does not Exist
Can arrays in Javascript contain functions
Strign Objects
passing file directory to function