Re: Breaking the sentence into words

From: Phouka <phouka_at_frii.com>
Date: 1998/02/24
Message-ID: <34F35154.128F_at_frii.com>#1/1


Ashish Hairat wrote:
>
> I am taking a string input using Varchar2 now the string has a sentence
> and I want to extract each word from the string. Is there any function
> in PL/SQL which can do the job without using Pro C?
>
> Anurag

You can use the instr() function to find each space in the sentence and then substr() between the spaces.

Robin
phouka_at_frii.com Received on Tue Feb 24 1998 - 00:00:00 CET

Original text of this message