Mapa mental
Cursor
Contenido del mapa
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
Información
- Descripción
- 7 Database Design Mapa Mental sobre Cursor, creado por Lingyun song el 16/06/2016.
- Creado por
- Lingyun song
- Visitas
- 1
- Valoración