December 2000
Intermediate to advanced
224 pages
9h 52m
English
CLOSE CURSOR
The CLOSE CURSOR
command closes a server-side cursor created with a DECLARE
CURSOR
statement. MySQL does not support
server-side cursors, but does support extensive C programming
extensions.
|
Vendor |
Command |
|---|---|
|
SQL Server |
Supported |
|
MySQL |
Not supported |
|
Oracle |
Supported |
|
PostgreSQL |
Supported |
CLOSE { cursor_name }The cursor_name is the name of the cursor
created with the DECLARE CURSOR command.
This example from Microsoft SQL Server opens a cursor and fetches all the rows:
DECLARE employee_cursor CURSOR FOR SELECT lname, fname FROM pubs.dbo.authors WHERE lname LIKE 'K%' OPEN employee_cursor FETCH NEXT FROM employee_cursor WHILE @@FETCH_STATUS = 0 BEGIN FETCH NEXT FROM Employee_Cursor END CLOSE employee_cursor DEALLOCATE employee_cursor
The DEALLOCATE
statement in Microsoft
SQL Server releases the resources and data structures used by the
cursor, but Oracle, PostgreSQL, and MySQL do not use it.