Re: How to extract single characters in PL/SQL?
From: Alexander Moeckel <amoeckel_at_192.168.160.1>
Date: Thu, 12 Dec 2002 11:09:28 +0100
Message-ID: <at9n7v$hm6$1_at_innferno.news.tiscali.de>
Date: Thu, 12 Dec 2002 11:09:28 +0100
Message-ID: <at9n7v$hm6$1_at_innferno.news.tiscali.de>
Hi,
this should work:
Part1 := substr (field, 1, instr (field, chr(32)) - 1);
Part2 := substr (field, instr (field, chr(32)) + 1);
Alex
Ludwig Nörg wrote:
> Hi,
>
> I need to split a varchar2 field containing name and first name
> combined into 2 fields, a blank as separator.
>
> How can I do this in Oracle SQL or PL/SQL?
>
> Any suggestions is helpful.
>
> Thanks
> Ludwig Nörg
Received on Thu Dec 12 2002 - 11:09:28 CET