1.open
2.close
3.fetch
4.insert

1.open
2.close
3.fetch
4.insert

Insert is Odd, which is not a part of CURSOR syntax.

Even though it is not a part of CURSOR syntax, can't I do an Insert using a cursor ?

You can do whatever you like within the Cursor; But question is like that .

Insert clause is odd among the list.
Open,fetch,close are the stages of cursor ,whereas 'Insert' statement declares implicit cursor(for insert) which goes through these three stages.

Adding to it,an Insert Cursor is a database cursor declared with a restricted form of the INSERT statement, designed to perform buffered row insertion in database tables.

The insert cursor simply inserts rows of data; it cannot be used to fetch data.

insert is odd because it is not related to cursor .

the odd man out is insert

Fetch is odd among them....