Mindmap
Cursor
Inhalt der Mindmap
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
Informationen
- Beschreibung
- 7 Database Design Mindmap am Cursor, erstellt von Lingyun song am 16/06/2016.
- Erstellt von
- Lingyun song
- Aufrufe
- 1
- Bewertung