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

Hallo Ludwig,

as usual:
[Quoted] [Quoted] 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
Received on Thu Dec 12 2002 - 10:53:27 CET