What I am look for is - Is there a way to avoid the table to store those
strings?
For the examples shown;
create table tab1
(col1 varchar10);
insert into tab1 values('test1');
insert into tab1 values('test2');
On Tue, Aug 2, 2011 at 2:40 PM, Gayathri <[email protected]> wrote:
> Hi All,
>
> Here is what I tried, Please suggest if any other better way to do this:
>
>
> set
> serveroutput on;
>
> declare
>
> string1
> varchar2(100);
>
> begin
>
> string1
> := '[test1][test2][test3]';
>
> for i in (select col1 from tab1) loop
>
> string1
> := regexp_replace(string1, i.col1);
>
> end loop;
>
> string1
> := regexp_replace(string1, '\[|\]');
>
> if (length(string1) > 0 ) then
>
> *dbms_output.put_line*
> ('more exists');
>
> else
>
> *dbms_output.put_line*
> ('all exists');
>
> end if;
>
> end;
>
>
>
>
>
>
>
>
> On Tue, Aug 2, 2011 at 2:07 PM, Gayathri <[email protected]> wrote:
>
>> Hi All,
>>
>> I have a set of strings: test1, test2, test3, test4, test6, test89,
>> test100
>>
>> and a contatinated string something like -
>> '[test3][test1][test5][]test34][test5][test100][test89]'
>> need to check if all the strings in the set of strings are in the
>> concatenated string?
>>
>> I can load the string set into a table and loop thr each one and then
>> compare if it exists in the concatenated string.
>>
>> Please suggest how do I code this?
>>
>> Thanks
>> G
>>
>
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
