SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

comparing 2 comma separated value strings

SmileMar 13 2012 — edited Mar 14 2012

Hi

I've the following requirement where i need to comapre 2 strings having comma separated values.

declare
 v_Str1 varchar2(100) ;
 v_str2 varchar2(100);
begin
 v_str1 := '123,234,456' ;
 v_str2 := '123,234';

/*  *I need to write a logic to compare the above 2 strings 
Could you please give me  hint to achieve this*  */

Thanks

Edited by: smile on Mar 13, 2012 8:20 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2012

Added on Mar 13 2012

15 comments

4,882 views