Oracle PL-SQL Question:
State the difference between implict and explict cursors?
Answer:
Implicit Cursor are declared and used by the oracle internally. whereas the explicit cursors are declared and used by the user. more over implicitly cursors are no need to declare oracle creates and process and closes autometically. the explicit cursor should be declared and closed by the user.
Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query
Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query
| Previous Question | Next Question |
| How to avoid using cursors? What to use instead of cursor and in what cases to do so? | How to know the last executed procedure? |