Question

如何在oracle中 删除第一个表在其他表中的数据

Answer 1

用关联关系，知道数据然后用in函数

Answer 2

delete table1 where exists (select 'x' from table2 where col1=table1.col1 and col2=table1.col2);

Answer 3

delete from table1
where 字段 in (select 字段 from table2

Answer 4

delete table1 where columnName in (select columnName from table2 where 条件)

。。。

Answer 5

查看他关联哪些表啊
就能对症下药了啊