Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A function that parses a string

 
Vladan Radovanovic
Ranch Hand
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use following function when u know the index from where u have to find substring.
substr(vcustomer_fname,initial_index,final_index)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic