Re: PL/SQL and parsing a variable for whitespace

 in_string := ''''||replace(in_string,,' ',''',''')||'''';

John

>I am trying to parse out a variable where it contains whitespace. For
>example: Lets say I have the variable called in_string varchar2(100) :=
>'This is a test'
>I want to parse this variable so that every time it finds a whitespace
>character, it creates a substr. So after I parse it, I should have four
>substr, 'This', 'is', 'a', 'test'
Received on Tue Oct 14 1997 - 00:00:00 CDT