Link to home
Start Free TrialLog in
Avatar of mahjag
mahjag

asked on

oracle built in funciton

Is there a function/analytical in oracle that converts a comma seprated string to rows - ? I am using oracle 11
Avatar of Sean Stuber
Sean Stuber

no, nothing built in  - at least, nothing general purpose

search EE or asktom.oracle.com  for str2tbl
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
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial