Re: parsing using sql help please

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 10 Jan 2012 14:06:27 -0500
Message-ID: <CAMVw97JXCDXbc49K9uM4yHaoCBSafEv3wD2AvkFeT9LNASqE1A_at_mail.gmail.com>

> Can instr() be used to search in reverse?

Yes it can,

SQL> select substr('Eugene � � Pipko', instr('Eugene � � Pipko', ' ', -1)+1) last_name� 2 � from dual;

LAST_NAME--------------------------------Pipko

On Tue, Jan 10, 2012 at 1:58 PM, Eugene Pipko <eugene.pipko_at_unionbay.com> wrote:

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 10 2012 - 13:06:27 CST