File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "A function that parses a string" Watch "A function that parses a string" New topic

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?
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

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.

Perfect World Programming, LLC - iOS Apps
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.
I agree. Here's the link:
subject: A function that parses a string
jQuery in Action, 3rd edition