Cursor concept of the SQL

[rooki]

Hi,

I have question regarding the Cursor concept of the SQL. I have gone through various book but didn't get proper information regarding this. What is the use of the Cursor in SQL? What is the syntax for cursor statement?

Please help me in this, I will appreciate your help over this.

[Reegan]

Hi,

In the SQL the Cursor concept is implemented using the "Declare cursor" statement. If you want o specify rules like authorization then you can "Select statement" along with the Cursor statement. We are able to use command like "delete" and "Update" along with the Cursor statement for the table rows which are only in the similar work unit. Refer below example of Cursor statement:

EXEC SQL declare a1 cursor for
select DPTNO, DPT_NAME, MRNO
FROM DPT
WHere MRDEPT = 'z88';

[opaper]

Hi friends,

Please refer the some details regarding Cursor statement:

*.The Cursor command of the Sql which can be associated to a Cursor. The main function of the cursor is to identifies a SQL command from it's activation.

*.The Cursor concept of SQL is a mechanism to navigate in between manipulation of data OR of data records sets for retrieving.

[MindSpace]

Hi,

Following is the syntax to declare the Cursor in the SQL:

DECLARE nameOFcursor Cursor

(GLOBAL | LOCAL )

// this is the scope of the cursor

(OPTIMISTIC | READ_ONLY | SCROLL_LOCKS | )

(FAST_FORWARD | STATIC | KEYSET | DYNAMIC)

FOR updtae / select statement

I hope this will help you to understand the Cursor concept of the SQL.