Database - CURSOR

 Cursor is a pointer for easy traversal.

There are two types of cursor.

1.ANSI Cursor

--> Single row

Forward only Cursor -- It will return -1 (You can move next(forward)only

2.Enhanced Cursor(scroll cursor)--> Multiple rows.It can move either direction.

You can use Next,Prior,last,first,Absoloute,relative

Life Cycle of Cursor:-

~~~~~~~~~~~~~~~~

      1. Declare the cursor

      2. Open the cursor

      3. fetch the cursor  

      4. close the cursor

      5. deallocate the cursor

create table empsiva3(empno int,ename varchar(20))

insert into empsiva3 values(1,'siva')

insert into empsiva3 values(2,'Ranbhir')

insert into empsiva3 values(3,'Imrankhan')

insert into empsiva3 values(4,'Karthik')

select * from empsiva3

Declare disp_emps cursor

for

      select * from empsiva3

open disp_emps

fetch next from disp_emps  -->  Run this for mutiple times...

select @@cursor_rows

close disp_emps

deallocate disp_emps

'Scroll Cursor'

'You can use Next,Prior,last,first,Absoloute,relative '

Declare disp_empss scroll cursor

for

      select * from empsiva3

open disp_empss

fetch next from disp_empss

fetch first from disp_empss

fetch last from disp_empss

fetch prior from disp_empss

fetch absolute  2 from disp_empss

fetch relative 2 from disp_empss

select @@fetch_status

select @@cursor_rows

close disp_empss

deallocate disp_empss