Atul,
How about REPLACE('your_field',":","
")? ... with a newline between those last two double quotes Doug On May 17, 2010, at 6:56 PM, Atul Vohra wrote: > All, > > I am wondering if there is an oracle sql call that would split a character > field content -ex abc:xyz:def should return > abc > xyz > def > > Could do it in remedy but was looking to get in one call. > > Thanks > Atul > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Doug -- Doug Blair [email protected] +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<<inline: bmc_skilled_pro_ar.png>>
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
