oracle存储过程里动态执行SQL
……
--当传入学习中心编号时
? IF vSpotCode is not null THEN
???? vWhere:=vWhere || ' AND ass.SpotCode=' || vSpotCode;
? END IF;
? --当传入学生层次编号时
? IF vLevelCode is not null THEN
???? vWhere:=vWhere || ' AND ass.LevelCode=' || vLevelCode;
? END IF;
? --当传入专业编号时
? IF vSpecCode is not null THEN
???? vWhere:=vWhere || ' AND ass.SpecCode=' || vSpecCode;
? END IF;
……
?execute immediate 'update thesisapplyinfo TAI set TAI.StudyState=105 where TAI.Studentid in
??????????? (select ass.userid from all_studentinfo ass where ass.speccode = A.SPECCODE ' || vWhere || ')';
……
