create table tb_drivers( driver_id int, driver_name varchar2(30 char) );INSERT INTO tb_drivers(driver_id,driver_name) values(348,'12345'); INSERT INTO tb_drivers(driver_id,driver_name) values(352,'小三'); INSERT INTO tb_drivers(driver_id,driver_name) values(355,'易特'); INSERT INTO tb_drivers(driver_id,driver_name) values(360,'李大荣'); INSERT INTO tb_drivers(driver_id,driver_name) values(432,'张三'); INSERT INTO tb_drivers(driver_id,driver_name) values(431,'李四'); INSERT INTO tb_drivers(driver_id,driver_name) values(430,'王五'); INSERT INTO tb_drivers(driver_id,driver_name) values(429,'赵六'); INSERT INTO tb_drivers(driver_id,driver_name) values(428,'王麻子'); INSERT INTO tb_drivers(driver_id,driver_name) values(391,'葛二蛋');COMMIT; create table tb_buses( vid int, driver_id VARCHAR2(100 CHAR) );INSERT INTO tb_buses(vid,driver_id) values(102,'432,431,430,429,428'); INSERT INTO tb_buses(vid,driver_id) values(542,'391'); commit; col driver_ids for a40; col driver_name for a30; select t2.vid, t2.driver_id as driver_ids, t1.driver_id, t1.driver_name from tb_drivers t1 join tb_buses t2 on instr(t2.driver_id||',',to_char(t1.driver_id)||',')>=1;
select 司机表.* ,车辆表.* from 车辆表,司机表 where instr(车辆表.driver_id,司机表.driver_id)>0
select 司机表.* ,车辆表.* from 车辆表,司机表 where regexp_like(车辆表.driver_id,司机表.driver_id)
driver_id int,
driver_name varchar2(30 char)
);INSERT INTO tb_drivers(driver_id,driver_name) values(348,'12345');
INSERT INTO tb_drivers(driver_id,driver_name) values(352,'小三');
INSERT INTO tb_drivers(driver_id,driver_name) values(355,'易特');
INSERT INTO tb_drivers(driver_id,driver_name) values(360,'李大荣');
INSERT INTO tb_drivers(driver_id,driver_name) values(432,'张三');
INSERT INTO tb_drivers(driver_id,driver_name) values(431,'李四');
INSERT INTO tb_drivers(driver_id,driver_name) values(430,'王五');
INSERT INTO tb_drivers(driver_id,driver_name) values(429,'赵六');
INSERT INTO tb_drivers(driver_id,driver_name) values(428,'王麻子');
INSERT INTO tb_drivers(driver_id,driver_name) values(391,'葛二蛋');COMMIT;
create table tb_buses(
vid int,
driver_id VARCHAR2(100 CHAR)
);INSERT INTO tb_buses(vid,driver_id) values(102,'432,431,430,429,428');
INSERT INTO tb_buses(vid,driver_id) values(542,'391');
commit;
col driver_ids for a40;
col driver_name for a30;
select t2.vid, t2.driver_id as driver_ids, t1.driver_id, t1.driver_name
from tb_drivers t1 join tb_buses t2 on instr(t2.driver_id||',',to_char(t1.driver_id)||',')>=1;
where instr(车辆表.driver_id,司机表.driver_id)>0
where regexp_like(车辆表.driver_id,司机表.driver_id)