Split string [Answered]RSS

• • Reply
  lasantha

  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

  
  

  
  

  
  

  Check out my Coding Issues
• • Reply
  davidmuto

  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 

• • Reply
  Yousef_Jadal...

  Contributor

  5871 Points

  1502 Posts

  Re: Split string

  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