Cursor Not Found « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Cursor Not Found
1.If cursor not found, reset the value
2.Explicit Cursor and notfound
3.SQL%NOTFOUND and if statement
4.Exit When Cursor%NOTFOUND
5.Incorrect location of the EXIT WHEN statement.
6.Behavior of the NO_DATA_FOUND exception.
7.Use 'EXIT WHEN studentCursor%NOTFOUND' just after fetch statement
8.NO_DATA_FOUND vs. %NOTFOUND
9.Loop till exit when cursorName%notfound




10.Output last row in a cursor
11.fetch cursor till notfound