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

Tim X <timx_at_spamto.devnul.com> wrote in message news:<87lm2qwoh5.fsf_at_blind-bat.une.edu.au>...
> noergl_at_gmx.net (Ludwig Nörg) writes:
>
> > 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?
> >
>
>
> Have a look at the instr() and substr() functions. Essentially, use
> instr() to find where the space is and then call substr on the
> varchar2 string twice - once to get the bits up to the space and once
> to get the bit after the space.
>
>
> Tim

Hello guys,

[Quoted] [Quoted] thanx a lot for your postings - but 2 hours after my first posting I found that solution you described by myself in the horrible Oracle 9 Online SQL Reference. So the instr() helps, but I am in the terrible situation to split about 40 million customer data sets (input since 1973 ...) in totally 15 different occurrences :-(

So it seems there should be a lot of manual post-editing if it doesn't work ...

Ludwig Received on Tue Dec 17 2002 - 14:54:39 CET