Answered Questions
Difference between an implicit & an explicit cursor.
Asked By: Interview Candidate
| Asked On: Aug 29th, 2004
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return 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...
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
Whenever a DML operation done there is a implicit cursor present. Explicit cursor is defined by user. Whenever a query runs implicit cursor automatically runs. User have no control on it and can not o...
A) A cursor is a pointer to the results of a query run against one of more tables in the database. IMPLICIT CURSOR : PL/SQL declares and manages an implicit cursor every time you execute a SQL DML s...