SQL使用游标

//游标选项和特性
1.能使数据只读不该
2.能控制定向操作（向前，第一，最后等）
3.标记某些列可编辑，某些不可编辑
4.规定范围，使游标对某些请求可访问
5.对数据进行复制
游标主要用于交互式应用，用户可以滚动屏幕，对数据进行浏览和更改
//创建游标
SQL Server，My SQL:
DECLARE CustCursor CURSOR
FOR
SELECT * FROM Customers
WHERE cust_email IS NULL
Oracle:
DECLARE CURSOR CustCursor 
IS
SELECT * FROM Customers
WHERE cust_email IS NULL
//使用游标
OPEN CURSOR CustCursor//打开游标
Oracle:
DECLARE TYPE CustCursor IS REF CURSOR
	RETURN Customers%ROWTYPE
DECLARE CustRecord Customers%ROWTYPE
BEGIN 
	OPEN CustCursor;
	LOOP//循环
	FETCH CustCursor INTO CustRecord;//FETCH检索当前行，自动从第一行开始
	EXIT WHEN CustCursor%NOTFOUND;//取不出更多行时终止处理
	CLOSE CustCursor;
END
//使用游标
SQL Server
DECLARE @cust_id CHAR(10)
	      @cust_name CHAR(50)
	      @cust_email CHAR(255)
OPEN CustCursor
FETCH NEXT FROM CustCursor
	INTO @cust_id ,@cust_name,@cust_email 
...
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM CustCursor
	INTO @cust_id ,@cust_name,@cust_email 
...
END
CLOSE CustCursor//关闭游标