Re: How to get the part of the string?
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