Oracle PL-SQL Question:
Download Questions PDF

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

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext 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?