Difference between implicit & explicit cursor
Differentiate between implicit & explicit cursor.
only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop. Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT statement via the CURSOR…IS statement. An implicit cursor is used for all SQL statements Declare, Open, Fetch, Close. An explicit cursors are used to process multirow SELECT statements An implicit cursor is used to process INSERT, UPDATE, DELETE and single row SELECT. .INTO statements.
Related posts:
- I want to manually edit some entries in my database. How? There is no facility in Bugzilla itself to do...
Related posts brought to you by Yet Another Related Posts Plugin.