Re: Oracle Split Function

From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
To: Nagarajan.Subbiah@xxxxxxxx
Date: Mon, 30 Jan 2006 17:47:12 +0100

Raja,

   Check instr(). You can search backwards, that's what you want.

HTH

Stephane Faroult

Subbiah, Nagarajan wrote:

Hi List,

Which SQL function can help me get the file name from a string like this
"C:\program files\my apps\2005\reports_New.doc".?Do We have any split
function in Oracle? We are at Oracle 9.2.0.5.

Thanks,
Raja.
--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Oracle security elist?
  - From: Joe Armstrong-Champ

References:
- Oracle Split Function
  - From: Subbiah, Nagarajan

Re: Oracle Split Function

Other related posts: