• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

oracle built in funciton

Is there a function/analytical in oracle that converts a comma seprated string to rows - ? I am using oracle 11
0
mahjag
Asked:
mahjag
  • 2
1 Solution
 
sdstuberCommented:
no, nothing built in  - at least, nothing general purpose

search EE or asktom.oracle.com  for str2tbl
0
 
JacobfwCommented:
The DBMS_UTILITY can provide some of that functionality.

Take a look at what this person was able to do:
http://plsql.wikidot.com/forum/t-41518
0
 
sdstuberCommented:
that's what I meant by "nothing general purpose"

that returns a collection type (associative array),  not "rows"

however, you could iterate through the array and return a nested table collection to export as "rows"
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now