Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • create table a (str varchar2(100)); create table b (str varchar2(100)); insert into a (str) values ('1MATA0000001891'); insert into b (str) values ('MATA 0000001891'); commit; select * from a, b where a.str like '%' || replace(b.str, ' ', '') ?
    • by x (5851) on 2006.10.02 23:06 (#50689)
      create table a (str varchar2(100));
      create table b (str varchar2(100));

      insert into a (str) values ('1MATA0000001891');
      insert into b (str) values ('MATA 0000001891');

      commit;

      select * from a, b
      where a.str like '%' || replace(b.str, ' ', '')