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.

use Perl

All the Perl that's Practical to Extract and Report

Any SQL gurus out there?? (using Oracle) More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Or this? (Score:1)

by x (5851) on 2006.10.02 22:59 (#50688)

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, ' ', '') ?

Reply to This
- Re: (Score:1)
  
  by x (5851)
  
  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, ' ', '')

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.