oracle的delete 语法问题！兄弟们来吧

[wwl007]

DELETE par_bond
FROM PAR_BOND,
(SELECT FZQDM a
FROM Z_ZQXX,STORAGE_KIND_SUB
WHERE FZQDM>=BEGIN_CODE
AND FZQDM<=END_CODE AND STORAGE_CODE ='10601'
AND MARKET_CODE='2') t
where par_bond.bond_code=t.a
这样的删除语法在oracle里面怎么写？高手指点！

[small_roc]

Delete Par_Bound
Where par_Bound.bond_code
in (Select Fzqdm From 表1 ，表2 Where 条件)

使用 in 可能 效率低一点

[small_roc]

在数据库中如何实现将'2002-1-28' 修改成 '2002-01-28'?
To_date好像起不到相应的功效！~ 求助了 ！

[bobfang]

delete par_bond
where exists(SELECT 1
FROM Z_ZQXX,STORAGE_KIND_SUB
WHERE FZQDM>=BEGIN_CODE
AND FZQDM<=END_CODE AND STORAGE_CODE ='10601'
AND MARKET_CODE='2'
and par_bond.bond_code=FZQDM )

[wwl007]

这个速度和那个比较差别多大！

[wwl007]

谢谢！看看速度怎么样！o

[chen_cyh]

1* SELECT TO_DATE('2002-1-8') FROM DUAL
SQL> /

TO_DATE('2002-1-8')
-------------------
2002-01-08 00:00:00
================================================================



★★ chen_cyh ●

[zhuzhichao]

兄弟,我來了.

delete from par_bond
where exists(select 1 from (SELECT FZQDM a
FROM Z_ZQXX,STORAGE_KIND_SUB
WHERE FZQDM>=BEGIN_CODE
AND FZQDM<=END_CODE AND STORAGE_CODE ='10601'
AND MARKET_CODE='2') t
where par_bond.bond_code=t.a);

[zhuzhichao]

兄弟,我來了.

delete from par_bond
where exists(select 1 from (SELECT FZQDM a
FROM Z_ZQXX,STORAGE_KIND_SUB
WHERE FZQDM>=BEGIN_CODE
AND FZQDM<=END_CODE AND STORAGE_CODE ='10601'
AND MARKET_CODE='2') t
where par_bond.bond_code=t.a);

[zhuzhichao]

兄弟,我來了.

delete from par_bond
where exists(select 1 from (SELECT FZQDM a
FROM Z_ZQXX,STORAGE_KIND_SUB
WHERE FZQDM>=BEGIN_CODE
AND FZQDM<=END_CODE AND STORAGE_CODE ='10601'
AND MARKET_CODE='2') t
where par_bond.bond_code=t.a);

[zhoubf725]

一般用subquery来代替多表关联，如果数据量大的话，速度提高都会很明显。
还有注意index的使用。