Last post Oct 18, 2010 09:48 AM by Yousef_Jadallah
Participant
1195 Points
840 Posts
Oct 18, 2010 06:03 AM|lasantha|LINK
hi all
i want to spilt 115:USD:LKR this string from oracle script. return value should be 115.
pls provide me sql script
thanks
Member
120 Points
33 Posts
Oct 18, 2010 09:37 AM|davidmuto|LINK
I saw one here about half way down the page. Essentially it will make a temp table from your string a split it into rows.
http://articles.techrepublic.com.com/5100-10878_11-5259821.html
Contributor
5871 Points
1502 Posts
Oct 18, 2010 09:48 AM|Yousef_Jadallah|LINK
lasantha hi all i want to spilt 115:USD:LKR this string from oracle script. return value should be 115. pls provide me sql script thanks
SELECT SUBSTR('115:USD:LKR',0 , INSTR('115:USD:LKR',':')-1) FROM DUAL
Participant
1195 Points
840 Posts
Split string
Oct 18, 2010 06:03 AM|lasantha|LINK
hi all
i want to spilt 115:USD:LKR this string from oracle script. return value should be 115.
pls provide me sql script
thanks
Member
120 Points
33 Posts
Re: Split string
Oct 18, 2010 09:37 AM|davidmuto|LINK
I saw one here about half way down the page. Essentially it will make a temp table from your string a split it into rows.
http://articles.techrepublic.com.com/5100-10878_11-5259821.html
Contributor
5871 Points
1502 Posts
Re: Split string
Oct 18, 2010 09:48 AM|Yousef_Jadallah|LINK