oracle如何删除包含B列的A列
发布网友
发布时间：2025-01-06 21:00
共3个回答
热心网友
时间：3分钟前
其实你这就是删除A表中与B表一致的数据
delete from A where exisits (select 1 from B where B.B1=A.A1)
或者
delete from A where A.A1 in (select B.B1 from B)都行
热心网友
时间：1分钟前
DELETE FROM A WHERE A1 LIKE (SELECT '%'||B1||'%' FROM B);
具体测试步骤如下：
SQL> drop table a;
Table dropped
SQL> drop table b;
Table dropped
SQL> purge recyclebin;
Done
SQL> create table a (a1 varchar2(20));
Table created
SQL> insert into a values('nike online');
1 row inserted
SQL> insert into a values('night online');
1 row inserted
SQL> create table b (b1 varchar2(20));
Table created
SQL> insert into b values('nike');
1 row inserted
SQL> select * from a;
A1
--------------------
nike online
night online
SQL> select * from b;
B1
--------------------
nike
SQL> DELETE FROM A WHERE A1 LIKE (SELECT '%'||B1||'%' FROM B);
1 row deleted
SQL> select * from a;
A1
--------------------
night online
SQL>
热心网友
时间：2分钟前
用游标，加上循环。
