Re: Oracle Split Function

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 30 Jan 2006 17:47:12 +0100
Message-ID: <43DE4310.5070203@roughsea.com>

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.
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

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

Received on Mon Jan 30 2006 - 10:47:12 CST