在用for update时对select子句有什么限制?
能用orderby ,group by之类的子句么?
现在我换成这个select子句时出现下面错误
是不是嵌套select的问题?
如果是的话,那我如何用for update 表tblstudentsltcourse呢?
CURSOR curStudSltCourse(vyears varchar2, vtermID varchar2) IS
select t.rowsID,studentID,years,termID,sltCourseID,sltTime,processStatus,serverNO
from tblstudentsltcourse t
where (t.years = vyears) and
(t.termID = vtermID)
order by t.sltTime
for update ;
ORA-06550: 第 2 行, 第 0 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
begin case declare
exit for goto if loop mod null pragma raise return select
update while with 《an identifier》
《a double-quoted delimited-identifier》 《a bind variable》
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
《a single-quoted SQL string》 pipe |