Cursor Value « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Cursor Value
1.Cursor with a single value
2.Update statement with cursor variable
3.Server-side cursor variables.
4.A cursor FOR loop.
5.Cursor Variable Example 2
6.Read full table data from a cursor
7.Single column cursor
8.Use Complex cursor to simplify the pl/sql logic
9.Use cursor to do full table scan




10.Use data referenced by cursor to update table
11.Use number functions when creating a cursor value
12.Form sentences from database data
13.Two identical queries to demonstrate the impact of changes