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
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