SQL游标及事务PPT课件.pptVIP

*【例13-2】通过游标将教师表teacher中记录号为3的章红老师的职称由讲师”改为教授”。USEjwglGODECLAREteacher_coursorSCROLLCURSORFORSELECTteacher_name,professionFROMteacherFORUPDATEOFprofessionOPENteacher_coursorFETCHABSOLUTE3FROMteacher_coursorUPDATEteacherSETprofession=教授WHERECURRENTOFteacher_coursorFETCHABSOLUTE3FROMteacher_coursorCLOSEteacher_coursorDEALLOCATEteacher_coursor*13.3.2删除数据通过在DELETE语句中使用游标来删除表或视图中的行。被删除的行依赖于游标位置的当前值。删除数据语法形式如下:DELETE[FROM][[database.]owner.]{table_name|view_name}WHERECURRENTOFcursor_name其中:table_name|view_name:为要从其中删