Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.arcor-online.net!newsfeed.ision.net!news.is-europe.net!ision!not-for-mail From: "Guido Konsolke" Newsgroups: comp.databases.oracle.tools Subject: Re: How to extract single characters in PL/SQL? Date: Thu, 12 Dec 2002 10:53:27 +0100 Organization: Ye 'Ol Disorganized NNTPCache groupie Lines: 30 Message-ID: <1039686571.743729@news.thyssen.com> References: NNTP-Posting-Host: 149.211.49.31 X-Trace: goliath.news.is-europe.net 1039686809 11807 149.211.49.31 (12 Dec 2002 09:53:29 GMT) X-Complaints-To: abuse@is-europe.net NNTP-Posting-Date: 12 Dec 2002 09:53:29 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Cache-Post-Path: news.thyssen.com!unknown@170.56.164.197 X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) Xref: newsfeed1.easynews.com comp.databases.oracle.tools:55334 X-Received-Date: Thu, 12 Dec 2002 02:53:06 MST (news.easynews.com) 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" schrieb im Newsbeitrag news:a7148654.0212120123.2e47ca18@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