Re: How to extract single characters in PL/SQL?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 12 Dec 2002 18:53:29 GMT
Message-ID: <JW4K9.84$ep.9708848_at_newssvr13.news.prodigy.com>

Guido Konsolke wrote:
> Hallo Ludwig,
>
> as usual:
> 1. Please provide always the version of OS, RDBMS etc.
> 2. There's more than one way. Here's a funny one from a co-worker
> (sorry for wraps):
>
> select substr('Albert Einstein',1,instr('Albert Einstein',' ')-1) from dual
> union all
> select substr('Albert Einstein',instr('Albert Einstein','
> ')+1,length('Albert Einstein') -instr('Albert Einstein',' ')) from dual
>
> hth,
> Guido
>
> "Ludwig Nörg" <noergl_at_gmx.net> schrieb im Newsbeitrag
> news:a7148654.0212120123.2e47ca18_at_posting.google.com...
>

>>Hi,
>>
[Quoted] >>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

>
>
>

And hope you don't run into Erich Von Danikan in your database. :) Received on Thu Dec 12 2002 - 19:53:29 CET