作者erho (ptt访客)
看板Database
标题[SQL ] 删除特定条件的语法问题
时间Wed Aug 20 17:40:27 2008
我的资料库是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
1F：推 slalala:delete不需要栏位 08/20 19:50
2F：推 grence:delete tablename from (ooxx)..maybe 08/20 19:52
3F：→ erho:回grence,这样语法依然有错SQL command not properly ended 08/21 09:05