推 slalala:delete不需要欄位 08/20 19:50
推 grence:delete tablename from (ooxx)..maybe 08/20 19:52
→ erho:回grence,這樣語法依然有錯SQL command not properly ended 08/21 09:05
我的資料庫是oracle
我要刪掉滿足下列語法的所有資料
select he_code,eff_date from newmed
minus
select he_code,max(eff_date) from newmed group by he_code;
我用
delete * from (select he_code,eff_date from newmed minus
select he_code,max(eff_date) from newmed group by he_code);
oracle 回應我錯誤訊息
ERROR at line 1:ORA-00903: invalid table name
若把 * 號去掉則錯誤訊息為
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
請問我要如何修正我的delete 語法
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.117.153.33