Mind map
Cursor
Map content
Cursor
- Oracle process SQL command --> context area (active set contains the results) cursor: pointer to the context-->get data from database to PL/SQL program -->enable PL/SQL to manipulate the SQL DML results
Implicit cursor
- Created automatically Not declared, no name Created when DELETE, UPDATE and INSERT issued Used in SELECT when only one record return
- created automaticaly
- Not declared, no identifier
- Generated during DELETE, UPDATE AND INSERT
- Used when only one SELECT result return
Explicit cursor
- Only used with SELECT
- Declared before BEGIN
- Steps
- Declare -- Open -- Fetch --process -- Close
Information
- Description
- 7 Database Design Mind Map on Cursor, created by Lingyun song on 16/06/2016.
- Created by
- Lingyun song
- Views
- 1
- Rating