如何将带区号的电话号码拆分
create table tel(code varchar(20));
insert into tel values ('01066667788');
insert into tel values ('010-55667788');
insert into tel values ('075556567788');
create table reg(code varchar(20),city varchar(20));
insert into reg values('010','北京');
insert into reg values('020','广州');
insert into reg values('0755','深圳');
输出
北京 66667788
北京 55667788
深圳 56567788
insert into tel values ('01066667788');
insert into tel values ('010-55667788');
insert into tel values ('075556567788');
create table reg(code varchar(20),city varchar(20));
insert into reg values('010','北京');
insert into reg values('020','广州');
insert into reg values('0755','深圳');
输出
北京 66667788
北京 55667788
深圳 56567788
select ltrim(substr(tel.code,length(reg.code)+1),'-'),reg.city
from tel,reg
where tel.code like reg.code||'%';
from tel,reg
where tel.code like reg.code||'%';
不存在的查询:
SELECT NAME_B
FROM TABLE_B B
WHERE NOT EXISTS (SELECT *
FROM TABLE_A A
WHERE A.NAME_A = B.NAME_B)
FROM TABLE_B B
WHERE NOT EXISTS (SELECT *
FROM TABLE_A A
WHERE A.NAME_A = B.NAME_B)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13545951/viewspace-547191/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13545951/viewspace-547191/