Mapa mental
Cursor
Conteúdo do 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
Informações
- Descrição
- 7 Database Design Mapa Mental sobre Cursor, criado por Lingyun song em 16-06-2016.
- Criado por
- Lingyun song
- Visualizações
- 1
- Avaliação