Re: How to get the part of the string?

From: Roger Stapley <roger.stapley_at_oracle.com>
Date: Tue, 27 Nov 2001 17:08:40 +0000
Message-ID: <3C03C898.F5D0F08B_at_oracle.com>


Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

[Quoted] SELECT SUBSTR('abcdef&123', INSTR('abcdef&123',CHR(38),1)+1, 100) FROM DUAL ; "Богомол Александр Анатольевич" wrote:

> Hi guys!
> I need your help.
> I have the following string :
> 'abcdef&123'
> Is it possible to retrieve the part of the string after '&' character,
> using one statement?
>
> Thanks in advance.
> Alex

--------------2DC8B0AB4A28B048670CB78B
Content-Type: text/x-vcard; charset=UTF-8;  name="roger.stapley.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Roger Stapley
Content-Disposition: attachment;

 filename="roger.stapley.vcf"

begin:vcard
n:Stapley;Roger
tel;work:+44 118 92 47294
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:Roger.Stapley_at_oracle.com fn:Roger Stapley
end:vcard

--------------2DC8B0AB4A28B048670CB78B-- Received on Tue Nov 27 2001 - 18:08:40 CET

Original text of this message