Note 1

Take Note:

Take a note while surfing.

Note With Ink

Give your Note a Colorful Tag.

Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.

Think With Ink

Differ your Content by Color.

Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape

Note With Ink

Simple an Easy Way to take a note.

Easy to Access

Get the same in next visit.

Please wait...

Technical Discussion :: Oracle PLSQL

7. What is Cursor and How many types of Cursor you have used?


Cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from a table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval.

There are mainly 2 types of cursors .
1) Implicit Cursor.
2) Explicit Cursor.

Implicit Cursor: Oracle will implicitly creates an area for the DML operations. Programmer will not have control on implicit cursors. The only useful attribute on this implicit cursor is SQL%ROWCOUNT , it will give the number of rows affected by the recent DML operation.

Explicit Cursor: created by the programmer and programmer have control on it Programmer can
1) Open 2) Close 3) Fetch
one by one and remove rows which have duplicate values.

Explicit Cursors are classified into
1) Normal cursor
2) Parameterized cursor
3) Cursor For Loops and
4) REF cursors

Asked In ::  Syntel Inc.  

Post Your Answer Here:

Post Your Reply Here:

Alert me

Report Error

Please Login First Click Here

Most Popular Qs.