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

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 12 Dec 2002 18:59:40 GMT
Message-ID: <w05K9.88$ep.9708848_at_newssvr13.news.prodigy.com>

[Quoted] Karsten Farrell wrote:

> 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,
>>>
>>> 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. :) >
BTW, in case someone doesn't catch it ... I'm not referring to the fact that Von Danikan corresponds with aliens ... I'm referring to the fact that he has a space in his last name. Received on Thu Dec 12 2002 - 19:59:40 CET